WayneS

Forum Replies Created

Viewing 15 posts - 901 through 915 (of 5,588 total)

RE: Reindexing issue on SQL Server 2005 Standard Edition

Another question related to this. Tech Support people are saying that we didn't start having this problem until the server was upgraded. It went from a 4-core 8GB ram system,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 23, 2012 at 7:30 am

#1450853
RE: Reindexing issue on SQL Server 2005 Standard Edition

GilaMonster (2/22/2012)
ALTER INDEX... REORGANISE instead of rebuild, or persuade for an Enterprise Edition upgrade (for online index build/rebuild)
Okay, so what I see that we're down to is:
1. Upgrade to EE.
2....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 22, 2012 at 2:39 pm

#1450571
RE: Reindexing issue on SQL Server 2005 Standard Edition

Lynn Pettis (2/22/2012)
This may sound a bit ridiculous, but if you aren't using index hints what about periodically building a redundent index and then drop the fragmented one? Not...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 22, 2012 at 11:19 am

#1450466
RE: Reindexing issue on SQL Server 2005 Standard Edition

GilaMonster (2/22/2012)
WayneS (2/22/2012)
I've thought about running each index to be re-indexed through SQLCMD, and then aborting it after a period of time (say, 30 seconds). This would let some pages...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 22, 2012 at 7:45 am

#1450299
RE: Are the posted questions getting worse?

Hey Threadizens,
Running into a re-indexing issue over here. All thoughts and advice appreciated!
Thanks,
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 22, 2012 at 7:24 am

#1450269
RE: Are the posted questions getting worse?

Roy Ernest (2/10/2012)
Thx for all the advice. Yes, they have plans for me to go higher up in the management. I have been asked to manage all Development teams and...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 13, 2012 at 7:52 am

#1446250
RE: Are the posted questions getting worse?

jcrawf02 (2/9/2012)
Seems timely on the heels of Lynn's news, a big THANK YOU to everyone who sent good thoughts my way a few weeks ago, I was nervous because....we're having...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 13, 2012 at 7:42 am

#1446241
RE: Are the posted questions getting worse?

Lynn Pettis (2/7/2012)
Now that it is officially posted on facebook, I can start telling everyone.
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 13, 2012 at 7:35 am

#1446234
RE: Are the posted questions getting worse?

bitbucket-25253 (2/1/2012)
Prior last post Posted Today @ 1:03 PM
Now 8:25 PM DECLARE @t TIME
SELECT @t = '7:22'
SELECT DATEDIFF(mi, 0, @t)
Which is 442 minutes
What did the site crash, this thread...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 1, 2012 at 6:39 pm

#1441510
RE: Are the posted questions getting worse?

Brandie Tarvin (2/1/2012)
MysteryJimbo (2/1/2012)
Koen Verbeeck (1/31/2012)
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 1, 2012 at 7:28 am

#1441210
RE: Casting and implied data type conversion

GilaMonster (1/23/2012)
WayneS (1/23/2012)
As long as one of the values is a decimal, the "/" will return a decimal value. So this will also work:
UPDATE TABLE SET COLUMN_A=COLUMN_A+(COLUMN_B/50.0)
However, Gail's comments about...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2012 at 12:55 pm

#1437340
RE: Are the posted questions getting worse?

GilaMonster (1/23/2012)
jcrawf02 (1/23/2012)
SQLRNNR (1/23/2012)
jcrawf02 (1/23/2012)
Blargh. User just requested a pie chart for their analysis....:sick:
Make sure you do that entirely in TSQL
challenge accepted, now let's see how long that takes me...
Oooh......
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2012 at 12:46 pm

#1437335
RE: Casting and implied data type conversion

As long as one of the values is a decimal, the "/" will return a decimal value. So this will also work:
UPDATE TABLE SET COLUMN_A=COLUMN_A+(COLUMN_B/50.0)
However, Gail's comments about lack of...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2012 at 11:32 am

#1437275
RE: Match Canceling Records

Good job of posting sample data, but the table definition is a bit unclear... everything is going to be stored as an integer.
So, based upon this sample data, what are...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2012 at 11:28 am

#1437273
RE: SVN for DB Objects? Need help with Setup!

Red-Gate's SQL Source Control[/url] works with SVN, and it sounds like it will do what you're asking.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2012 at 11:24 am

#1437269

Viewing 15 posts - 901 through 915 (of 5,588 total)