Viewing 15 posts - 14,116 through 14,130 (of 22,211 total)
You do have to define refresh. For example, we do a regular "refresh" where in we move the production database down to our QA environment through a backup and restore....
October 12, 2010 at 6:39 am
In regards to the question, it does fill books. I'd take a look at the first two chapters of Itzik Ben-Gan's book, Inside T-SQL Querying. It's a good overview of...
October 12, 2010 at 6:36 am
RonKyle (10/12/2010)
I think there's a bit too much fear around GUIDs.
Fear isn't the issue. In situations for which there is a simpler solution, they are a royal pain.
'
Oh absolutely....
October 12, 2010 at 6:01 am
Brandie Tarvin (10/12/2010)
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
A cheaper room-mate?...
October 12, 2010 at 5:49 am
reggie burns-317942 (10/11/2010)
Thanks for all the input.
After running update statics on 5 of the must active tables the queries are running much better, as if it was still in...
October 12, 2010 at 5:43 am
I think there's a bit too much fear around GUIDs. In my own experiences, as long as they're not the clustered key, even the sequential ones, you generally won't have...
October 12, 2010 at 5:37 am
Also CATCH won't catch syntactical (is that a word) errors, so you may see two errors in fact, but you'll only catch one
October 8, 2010 at 4:17 pm
Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.It's nice to see everyone can learn.
I...
October 8, 2010 at 3:51 pm
Best thing you can do is pick up a copy of Itzik Ben-Gan's Inside SQL Server TSQL Querying. Make all the developers read that. That'll do more positive than any...
October 8, 2010 at 11:37 am
At this point in time, coming up on 2011, SQL Server 2005 is six years old and 2008R2 is 9 months old. There'll be a new version (either SQL Server...
October 8, 2010 at 11:33 am
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Grant Fritchey (10/8/2010)
what is it we do for work again?
Work is a four letter word. My mother taught me to behavior better...
October 8, 2010 at 9:03 am
Chris Morris-439714 (10/8/2010)
Grant Fritchey (10/8/2010)
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
October 8, 2010 at 8:40 am
steveb. (10/8/2010)
Pradyothana Shastry (10/8/2010)
Check the indexes and as well as fragmentation level toowould an upgrade change the fragmentation level?
Assuming either a restore or attach style upgrade.... nope.
There are some...
October 8, 2010 at 6:22 am
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
October 8, 2010 at 6:08 am
I'm a huge fan of side-by-side upgrades. So far, knock wood, I haven't had a single 2008 upgrade go wrong, but if one did, having the 2000 server sitting there...
October 7, 2010 at 1:13 pm
Viewing 15 posts - 14,116 through 14,130 (of 22,211 total)