|
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs
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
Congrats nakul...I m one of the almost regular reader of your blog....
Plz keep it up......
|
|
|
|
|
-
Krishnrajsinh Rana Commented 5 Months ago through Ask
OK Got it...
But i m always try to avoid the use of UNIQUEIDENTIFIER column in the table.(if possible).
Any ways, As a DBA what are the other things that i have to keep in mind ??
Thanks again for reply......
|
-
Krishnrajsinh Rana Commented 5 Months ago through Ask
Hi Jacob,
Thanks for the reply, but i have one doubts as you said -
> there are chances that you fix the excessive fragmentation by tweaking the schema
I don't understand, i mean what do you mean by "tweaking the schema"?
Thanks...
|
-
Krishnrajsinh Rana Posted 5 Months ago through Ask
Hello Experts,I need your suggestion / feedback regarding automation of database rebuild / reorganize indexes. For the frequently updated database, should i have to manually rebuild / reorganize the indexes as per the Total fragmentation or i have to ma...
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs
In this post, I explore whether one can use the SQL Server Management Studio (SSMS) can be used to test a connection string. This is related to the post I wrote ealier about how adding the Application Name and the Workstation ID in a connection string a...
|
-
Krishnrajsinh Rana learned 5 Months ago through Blogs
In this post, I explore whether one can use the SQL Server Management Studio (SSMS) can be used to test a connection string. This is related to the post I wrote ealier about how adding the Application Name and the Workstation ID in a connection string a...
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs
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....
|