|
|
-
vanne040 Learned 1 Years ago through Just Learned
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...
|
-
vanne040 Liked 1 Years ago through Just Learned
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...
|
-
vanne040 Learned 1 Years ago through Just Learned
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...
|
-
vanne040 Liked 1 Years ago through Blogs
This is just example of use CHECKSUM to avoid writing to much in comments section at http://beyondrelational.com/modules/1/justlearned/388/tips/11035/checksum-checksumagg.aspx...
|
-
vanne040 learned 1 Years ago through Blogs
This is just example of use CHECKSUM to avoid writing to much in comments section at http://beyondrelational.com/modules/1/justlearned/388/tips/11035/checksum-checksumagg.aspx...
|
|
|
|
|
-
vanne040 Commented 1 Years ago through Just Learned
Thanks for pointing out Ashish. For user databases, we need to use the below syntax after moving the files to the required location.
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name ' )
Th...
|
-
vanne040 Commented 1 Years ago through Just Learned
Thanks for pointing out Ashish. For user databases, we need to use the below syntax after moving the files to the required location.
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name ' )
Th...
|
-
vanne040 Posted 1 Years ago through Just Learned
I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this I h...
|