Viewing 15 posts - 3,451 through 3,465 (of 49,552 total)
yb751 (3/15/2016)
Is this what you are really trying to do?
Probably not. He's probably trying to use an = for the upper end of a date range, which isn't the best...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 7:56 am
vivekgrover44 (3/15/2016)
At the time of index creating, above mentioned points came into my mind that what should be deciding factor for this case.
You can't create useful indexes based only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 7:53 am
DATE is a date without a time component. Therefore you can't subtract microseconds from it.
SET @End_Date = DATEADD(DAY ,7 ,@The_Date)
and then instead of using BETWEEN @Start_Date and @End_Date, rather...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 7:51 am
Without seeing the queries that run against the table, absolutely no way to say.
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 7:41 am
Ed Wagner (3/15/2016)
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 5:32 am
Grant Fritchey (3/15/2016)
CXPacket is only a concern if you also see other CPU waits.
I tend to worry about it if I also see parallelism-related latch waits. But that's worry to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 5:29 am
Brandie Tarvin (3/15/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 4:02 am
I don't understand the request, can you be clearer please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 2:58 am
sunny.tjk (3/14/2016)
Could PAGIOLATCH_XX waittypes be a good indication?
It's an indication of buffer pool churn. Whether that's due to insufficient memory, bad queries or poor indexing is another matter.
Oh, and CXPacket...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 2:56 am
alno (3/14/2016)
You guys wouldn't happen to know if turning it off requires a SQL restart
Before you turn it off, make sure it isn't required by your company's audit or security...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 2:53 am
Someone's implemented a DDL trigger somewhere, and it's broken.
Check in Object Explorer. Each DB, programability, triggers or Server Objects-> triggers for server-wide triggers (which is probably more likely where this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 2:51 am
It's coming from this fragment: @TheDate -1
You can't add or subtract integers from a DATE variable. Try DATEADD(dd,-1,@TheDate) in both places where that occurs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2016 at 2:46 am
Threads are required to process logins.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 10:06 am
Not offhand, no. You'll probably need a job that runs every (x) minutes, checks the state and then takes any necessary action. Won't be much overhead if it does nothing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 8:48 am
2) Because the log records still have to be sent to the secondary. If they could be removed from the log before being sent to the secondary, then you'd have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 8:34 am
Viewing 15 posts - 3,451 through 3,465 (of 49,552 total)