Viewing 15 posts - 1,321 through 1,335 (of 2,458 total)
jonathanm 4432 (7/21/2015)
Never used powershell. Is it something that is easily learned and can be done?
July 21, 2015 at 10:12 am
WebTechie (7/21/2015)
I recently migrated a production environment from a Windows 2003 server with SQL Server 2005 (SVPK 2). I migrated the environment to a Windows 2008 Server with SQL...
July 21, 2015 at 10:06 am
lmarkum (7/17/2015)
Thanks for the comments. If an index has 50 reads and 1 million writes, for example, then 99.9 of the usage of that index is spent on...
July 17, 2015 at 10:37 pm
Steven Willis (4/19/2013)
Jeff Moden (4/14/2013)
Please consider using a Tally Table instead of a recursive CTE to count. Please see the following article as to why.
Thanks for the suggestion Jeff....
July 17, 2015 at 9:32 pm
The number of reads on some of these did give me pause, despite the out of balance ratio to writes.
There's no reason (based on the information you have provided...
July 17, 2015 at 7:13 pm
Welsh Corgi (7/17/2015)
Alan.B (7/16/2015)
Is there a work around?
If it's possible to index the view that would would be an option.
That is not going to work.
Thanks.
That's bummer. I have never...
July 17, 2015 at 5:31 pm
[Quote]In some cases there are a few hundred thousand
reads but maybe a million writes on the index.[/quote]
That's not the best way to determine if you should keep an index....
July 17, 2015 at 2:51 pm
There's not enough information here to give you a definitive answer.
Could you post:
1. The DDL for both tables
2. The query plan produced when you do a SELECT * from...
July 17, 2015 at 2:25 pm
DonlSimpson (6/30/2015)
Alan.B (6/30/2015)
Based on my testing, the function appears to perform a bit faster using CHECKSUM over ROW_NUMBER() instead of the conversion to BIGINT in the TOP clause.
http://www.sqlservercentral.com/Forums/Topic1585850-391-3.aspx
So it...
July 16, 2015 at 4:26 pm
Is there a work around?
If it's possible to index the view that would would be an option.
July 16, 2015 at 4:16 pm
SQLRNNR (6/30/2015)
Congrats Alan!!!What is that building in the background?
Thank you sir. That's a Northwestern University building - I think it's the medical school but it could be the law...
June 30, 2015 at 8:28 pm
SQLRNNR (6/30/2015)
Alvin Ramard (6/30/2015)
Is it ok to suggest dropping...
June 30, 2015 at 8:22 pm
Thank you everyone for the kind words!
June 30, 2015 at 11:05 am
spaghettidba (6/29/2015)
Congrats Alan! My second daughter turns 3 months on Friday and I can confirm that SQL stands for Sleep Quality Lowered in this case 😀
Brilliant and so true!
June 30, 2015 at 11:01 am
DonlSimpson (6/30/2015)
ChrisM@Work (6/30/2015)
Nice job, Alan.One question: what's the CHECKSUM() for? It doesn't appear to change the result from ROW_NUMBER().
Same question.
PatExclude8K and PatReplace8K evolved from the thread at the end...
June 30, 2015 at 10:45 am
Viewing 15 posts - 1,321 through 1,335 (of 2,458 total)