Viewing 15 posts - 1,201 through 1,215 (of 2,462 total)
sqlstart wannabe (11/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 4:50 am
thanks Wayne, it worked for me
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 1, 2010 at 11:24 pm
@gail, Here i didnt mean "inlcude column" i meant to say , if i have clustered index on one column "Empid" . then how it would consider other non-participated columns.?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2010 at 9:38 pm
I would go with Second option.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2010 at 6:23 am
GilaMonster (10/27/2010)
Point is that the cluster is the largest index on the table (because it includes all columns).
Always ? What if i include only one column like empid in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2010 at 6:21 am
Its been a long while nobody has responded here because you are asking for homework.
Google the terms you are asking and test/implement on your local system
and then if you face...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2010 at 5:11 am
Removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 5:44 am
Any DML operation held in the night which disturbed the indexes/statistics.this could be one cause
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 5:44 am
Duran (10/27/2010)
I am trying to decide what the best course of action would be in regards to testing the performance of SQL in a multi instance cluster in test in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 5:42 am
ruchir 71291 (10/25/2010)
I would like to know the difference between ntext and vvarchar(max).
See this http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 4:05 am
Steve Jones - SSC Editor (10/25/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 3:57 am
subha.mcts2005 (10/21/2010)
what is maximum size of temp db?
Seems like interview question ?:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 3:27 am
We should also take Tape drive/Disk space under consideration where we are keeping backup file.
Like, what frequency of the backup should be ? daily/weekly etc ?
and for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 2:32 am
SKYBVI (10/26/2010)
Before doing any shrinking on prod server, if I backup the database, then is this fool proof?
This will not help you in space reclaim and Shrinking will not...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 2:15 am
sqlserver12345 (10/25/2010)
I need a t-sql (specifically a select statement) which can retrieve disk space(total/used/remaining..all drives)database space (total/used/remaining)Thanks
See how much below SP helps you.
Text
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE dbo.sp_SDS
@TargetDatabase sysname...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 27, 2010 at 2:07 am
Viewing 15 posts - 1,201 through 1,215 (of 2,462 total)