|
|
|
|
|
|
-
Krishnrajsinh Rana Liked 4 Months ago through Blogs | 1 Point
Primary data files are always assigned a file_id = 1 in the sys.database_files view. But, what about the log and rest of the data files? Does the primary transaction log file of a database always receive a file_id = 2?...
|
-
Krishnrajsinh Rana refreshed 4 Months ago through Blogs | 1 Point
Primary data files are always assigned a file_id = 1 in the sys.database_files view. But, what about the log and rest of the data files? Does the primary transaction log file of a database always receive a file_id = 2?...
|
|
|
-
Krishnrajsinh Rana Liked 4 Months ago through Blogs | 1 Point
Every DBA has a daily activity review or monitor database backups as these database backups used for the restoration at other place and using for the database restore which used for reporting purpose or used in log shipping purpose. Because database bac...
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs | 1 Point
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
-
Krishnrajsinh Rana refreshed 5 Months ago through Blogs | 1 Point
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs | 1 Point
Part 01 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....
|
-
Krishnrajsinh Rana Commented 5 Months ago through Blogs | 1 Point
Congrats nakul...I m one of the almost regular reader of your blog....
Plz keep it up......
|