|
|
-
Shivendra Kumar Yadav Liked 3 Months ago through Blogs
How to Split a single row coming in input file to multiple rows when number of columns are not fixed in the input file....
|
-
Shivendra Kumar Yadav Commented 3 Months ago through Blogs
HAVING clause run over group of data as like WHERE clause. it doesn't require GROUP BY clause until we we specify non aggregated column in select list.
Declare @Tab table(ID int, Value Decimal(18,2))
INSERT INTO @Tab
SELEC...
|
-
SQL Server 2012 supports up to 15,000 partitions by default.
In earlier versions, the number of partitions was limited to 1,000 by default...
|
-
SQL Server 2012 supports up to 15,000 partitions by default.
In earlier versions, the number of partitions was limited to 1,000 by default...
|
|
|
-
Shivendra Kumar Yadav Liked 5 Months ago through Blogs
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
-
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed but d...
|
-
Shivendra Kumar Yadav Commented 7 Months ago through Ask
Hello long time.. but I were not able to change that cursor into set based query but when I convert the participating table from main one to temp table with selected field and required indexes than it become 98% faster....
|
-
Shivendra Kumar Yadav Commented 8 Months ago through Ask
I m not able to upload the example may be because of size. but there is two nested cursor where at second level I have manipulation the intermediate values with update statement....
|
-
Shivendra Kumar Yadav Posted 8 Months ago through Ask
How to optimize the operation under cursor . I use "static" but still it is consuming much time.<br>...
|