sql-server-2008-r2 Questions
5
I am not sure if its possible, but would really appreciate any assistance.
I am looking for a script which can generate the complete list of SQL Server databases with the following details for eac...
Ellanellard asked 29/5, 2012 at 9:30
4
Solved
Is rowversion not a valid data type in Microsoft SQL Server 2008 R2?
Bonus Chatter
i'm trying to add a rowversion column to a table:
But when i try to leave the "Data Type" column, SQL Serve...
Wyckoff asked 23/1, 2012 at 20:27
5
Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate ...
Pleurodynia asked 25/3, 2013 at 5:46
9
Solved
I have the following table
Name | Subject | Marks
--------------------------
a M 20
b M 25
c M 30
d C 44
e C 45
f C 46
g H 20
Here I have a "Student" table I want to get the Name of ...
Perspicacity asked 5/8, 2013 at 12:28
5
Solved
I am creating below stored procedure.
declare @PageNum as Int
declare @PerPageResult as Int
declare @StartDate as varchar(25)
declare @EndDate as varchar(25)
declare @SortType as Varchar(50)
decla...
Wheelhouse asked 26/2, 2013 at 9:11
4
Solved
I am trying to connect Sql Server Data Base using windows authentication from my application using JTDS driver but i got following error
SSO Failed: Native SSPI library not
loaded. Check the ja...
Immunoreaction asked 15/6, 2011 at 10:55
8
I have a Delphi Application that is connected to a SQL Server db using SDAC component from DevArt, we have 200 installations of the software and only to a customer, with some users, I notice the fo...
Anode asked 26/1, 2012 at 11:10
3
Solved
I have a SQL Server 2008 database with a .mdf file with 1 GB and a .ldf file (log) with 70 GB. I really don't know what took my log file to be so big in a week and to stop to increase, but my main ...
Flyover asked 30/9, 2014 at 0:11
3
Solved
I have a Report Services instance that creates hundreds of jobs. The jobs are in serial format (ie. xxxxxx-xxx-xxxxx-xxxx-xxxx) and clutter up the jobs section view in SSMS. Is there any way to hid...
Hyde asked 30/7, 2012 at 14:56
6
While trying to access databases, logins, etc in SQL Server Management Studio 2008 R2, below error is always popping up. I browsed over google to find out a solution but those resolutions did not s...
Hooghly asked 17/1, 2017 at 11:30
6
Solved
I have (for testing purposes) many dbs with the same schema (=same tables and columns basically) on a sql server 2008 r2 instance.
i would like a query like
SELECT COUNT(*) FROM CUSTOMERS
on al...
Eng asked 27/8, 2013 at 10:0
5
Solved
What is the fastest way to export files (blobs) stored in a SQL Server table into a file on the hard drive? I have over 2.5 TB of files (90 kb avg) stored as varbinary and I need to extract each on...
Avarice asked 25/4, 2012 at 23:42
2
I have a query that I am putting in to a stored procedure. When I run the query with local variables the query takes ~1 second to run. When I put the same query inside of a stored procedure and cal...
Feinberg asked 16/12, 2015 at 20:18
4
Solved
In my MS SQL 2008 R2 database I have this table:
TABLE [Hierarchy]
[ParentCategoryId] [uniqueidentifier] NULL,
[ChildCategoryId] [uniqueidentifier] NOT NULL
I need to write a query that will ge...
Protoplasm asked 9/1, 2013 at 16:37
4
Our dev server has SQL Server 2008 R2 64-bit with SSIS. In order to be able to import XLSX files directly from T-SQL (via OPENROWSET), we installed on the dev server the Microsoft Access Database E...
Blumenfeld asked 3/11, 2014 at 16:1
3
Solved
I have posted something similar before, but I am approaching this from a different direction now so I opened a new question. I hope this is OK.
I have been working with a CTE that creates a sum of...
Hekate asked 2/4, 2014 at 9:33
5
Solved
I am using SQL Server 2008 R2.
I want the priority based sorting for records in a table.
So that I am using CASE WHEN statement in ORDER BY clause. The ORDER BY clause is as below :
ORDER BY ...
Corliss asked 21/10, 2013 at 5:31
6
Solved
I'm performing an UPDATE with OUTPUT query:
UPDATE BatchReports
SET IsProcessed = 1
OUTPUT inserted.BatchFileXml, inserted.ResponseFileXml, deleted.ProcessedDate
WHERE BatchReports.BatchReportGUID ...
Stabilizer asked 2/11, 2012 at 15:38
4
Solved
In my SSIS package, I have to converting values from DateTime to a corresponding INTEGER value. The following sample has been provided.
Any ideas as to how I can convert these?
DATETIME INT
-----...
Bandeau asked 31/3, 2011 at 20:30
5
Solved
As part of a stress tests I'm doing I'm trying to figure out if there is an SQL query (quite specifically SQL Server query) that will max all CPUs usage to 100% or close enough.
Suggestions anyone...
Conquian asked 17/7, 2014 at 18:25
15
Solved
I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build).
Sometimes when I run my build I get this error:
ALTER DATABASE failed because...
Robert asked 25/8, 2011 at 21:42
7
Solved
How can I search all columns of a table in SQL Server?
Evvy asked 27/10, 2011 at 21:36
8
Solved
I'm working with Sql server 2008.i have a table contains following columns,
Id,
Name,
Date
this table contains more than one record for same id.i want to get distinct id having maximum date.h...
Bonesetter asked 28/4, 2014 at 8:56
21
Solved
I've got dirty data in a column with variable alpha length. I just want to strip out anything that is not 0-9.
I do not want to run a function or proc. I have a script that is similar that just g...
Weirdo asked 4/9, 2013 at 23:41
10
I have a very large SQL Server 2008 R2 database (1.5TB) and will be copying some data from column to column within the same table. I've been told that the schema has a large number of indexes and w...
Vickivickie asked 10/9, 2015 at 15:17
1 Next >
© 2022 - 2024 — McMap. All rights reserved.