|
|
-
Pothiraj knew 1 Years ago through Just Learned | 1 Point
Sometimes while writing a query, we might have the requirement of dynamic sorting, i.e. sorting based on different column based on certain conditions.
To do this often developers will use dynamic queries. Without resorting to Dynamic queries, we can w...
|
-
Pothiraj forgotten 1 Years ago through Just Learned | 1 Point
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has be...
|
-
Pothiraj forgotten 1 Years ago through Just Learned | 1 Point
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has be...
|
-
Pothiraj forgotten 1 Years ago through Just Learned | 1 Point
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has be...
|
-
Pothiraj Liked 1 Years ago through Just Learned | 1 Point
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has be...
|
-
Pothiraj Liked 1 Years ago through Just Learned | 1 Point
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has be...
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
Recently I noticed that Deleting a database which is in offline leaves physical files intact......
|
-
Pothiraj Liked 2 Years ago through Just Learned | 1 Point
Recently I noticed that Deleting a database which is in offline leaves physical files intact......
|
-
Pothiraj Commented 2 Years ago through Just Learned | 1 Point
If we delete the offline database, we need to manually delete the physical files in that database....
|
-
Pothiraj Commented 2 Years ago through Just Learned | 1 Point
If we delete the offline database, we need to manually delete the physical files in that database....
|