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?
Check out Stairway to Powershell[/url]
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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....
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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....
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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.
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
June 30, 2015 at 8:28 pm
SQLRNNR (6/30/2015)
Alvin Ramard (6/30/2015)
Is it ok to suggest dropping...
-- Itzik Ben-Gan 2001
June 30, 2015 at 8:22 pm
Thank you everyone for the kind words!
-- Itzik Ben-Gan 2001
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!
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
June 30, 2015 at 10:45 am
Viewing 15 posts - 1,321 through 1,335 (of 2,458 total)