Viewing 15 posts - 10,546 through 10,560 (of 49,566 total)
How much usage does TempDB see? How much of that 50GB gets used?
December 27, 2013 at 5:11 am
kapil_kk (12/27/2013)
But if I add few column of non clustered index to unique constraint columns then also uniqueness will be retained.... so in that case can I go with this
Yes,...
December 27, 2013 at 4:28 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
And look in Books Online, lots of material on indexes in there.
December 26, 2013 at 2:00 pm
MohamedDBA (12/25/2013)
December 26, 2013 at 1:59 pm
ramana3327 (12/25/2013)
Please tell me which is the very bad performance issue.
All of them. None of them.
If there was a join operator that always was a performance problem, why would...
December 26, 2013 at 1:55 pm
kapil_kk (12/24/2013)
GilaMonster (12/24/2013)
kapil_kk (12/24/2013)
Should I drop unique constraint and make non clustered index only or add more column in unique constraint instead of creating another nonclustered index?
If the index is...
December 26, 2013 at 1:43 pm
cboneill181 (12/24/2013)
December 24, 2013 at 8:43 am
kapil_kk (12/24/2013)
Should I drop unique constraint and make non clustered index only or add more column in unique constraint instead of creating another nonclustered index?
If the index is there to...
December 24, 2013 at 7:21 am
ALZDBA (12/24/2013)
could you please add @@version information of that instance ?
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
December 24, 2013 at 7:10 am
tjaybelt (12/24/2013)
During undoing of a logged operation in database 'ILCentralDataEnt', an error occurred at log record ID (386988:95874:18). Typically, the...
December 24, 2013 at 7:09 am
You will only find lookups > 0 on clustered indexes. It is the number of key lookups that are done *to* that clustered index after a seek operation (or sometimes...
December 24, 2013 at 5:39 am
Hard to say anything useful from across the network, but if the output says that a directory doesn't exist, that's what the error is.
Double-check what account the job is running...
December 23, 2013 at 8:29 am
Steve-0 (12/23/2013)
D:\MSSQL.1\MSSQL\Backup\dailyprocessLog.bak1 File(s) copied
The system cannot find the path specified.
Have you checked that all paths referenced in that job step exist and are accessible
December 23, 2013 at 7:33 am
Edit the job, go to the advanced properties of the step and log output to file. There's nothing in the message you posted that is useful, the output of the...
December 23, 2013 at 7:04 am
It may be worth looking through the codebase for other similar procedures. I've typically found that if this kind of pattern is used in one place, it's used in a...
December 23, 2013 at 5:37 am
Viewing 15 posts - 10,546 through 10,560 (of 49,566 total)