|
|
-
Gaurang Patel Liked 7 Months ago through Blogs | 1 Point
How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....
|
-
Gaurang Patel Liked 8 Months ago through Blogs | 1 Point
What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the...
|
-
Gaurang Patel Commented 10 Months ago through Blogs | 1 Point
Congratulation to all winners....
|
-
Gaurang Patel Commented 10 Months ago through Blogs | 1 Point
While Rebuilding is index
table is in S Lock and Sch-M Lock
Pages of the table are in X Lock mode
But why we can not access table if table is in S Lock mode , index is created drop and created for rebuild purpose so All pages are created Again
and...
|
-
Gaurang Patel Commented 10 Months ago through Blogs | 1 Point
1.Tempdb does not Follow all ACID rules.
Answer of Bonus Question
1.Tempdb Does not follow property Durability.
2.Tempdb is created whenever sql server is restarted so all changes in tempdb are gone.what if system is crash and starts again we w...
|
-
Gaurang Patel Liked 1 Years ago through Blogs | 1 Point
Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code
declare @t table(i int)
select * from tempdb.INFORMATION_SCHEMA.TABLES
The result is
TABLE_CATALOG TABLE_SCHEMA TA...
|
-
Gaurang Patel Liked 1 Years 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....
|