Viewing 15 posts - 14,896 through 14,910 (of 39,824 total)
The clustered index is the physical order, so it helps in terms of ordering the data back if the table is scanned. So typically I try to cluster on columns...
October 25, 2011 at 9:24 am
In your first query, you aren't joining to the table you are deleting from.
What you should do is write a SELECT query first to find out what will be found....
October 25, 2011 at 9:19 am
What's funny is that it seems that people see the devices so differently. My wife misses her Blackberry, but likes her Android (Samsung Galaxy S, Android) more than her iPhone...
October 25, 2011 at 8:55 am
Joe Johnson-482549 (10/25/2011)
Lempster (10/25/2011)
It's a nice idea, but would involve getting access to HR data which, in my experience, HR departments tend to be rather twitchy about!
In the US, Sarbanes-Oxley...
October 25, 2011 at 7:54 am
richj-826679 (10/25/2011)
Human Resource departments are similar to IT departments in that both of them are a cost to the organization without generating revenue
How many companies can work successfully for a...
October 25, 2011 at 7:53 am
OCTom (10/25/2011)
If that's the case,...
October 25, 2011 at 7:52 am
Revenant (10/24/2011)
Much thanks for this one. I do appreciate how much thought went into this "small" piece.
I would just add one observation: being a database architect is a title...
October 25, 2011 at 7:50 am
Gonna be 6 or 7 games now.
Anyone see Pujols turn on that ball for the 3-run HR Sat night? As soon as he swung I told my wife "gone". I've...
October 24, 2011 at 2:02 pm
My guess is 2-4 weeks. Not sure how long the A/V company will take to process and upload things.
October 24, 2011 at 2:00 pm
GSquared (10/24/2011)
Post exact copies of it on a dozen or more other SQL Server sites, just sign it as if it were our own.
Each of...
October 24, 2011 at 10:04 am
GilaMonster (10/24/2011)
http://toostep.com/insight/daily-dba-morning-check-list
Steve's going...
October 24, 2011 at 9:48 am
HowardW (10/24/2011)
Just came across this:http://sqlserverboost.info/?p=204
Complete plagiarism, yes?[/url]
The rest of the site content looks equally dubious.
Reported to MS
October 24, 2011 at 9:47 am
Please do not ask for someone to take material from another place and give it to you for free. If you think the material is worth using, buy it yourself...
October 24, 2011 at 8:34 am
Before you do anything, I recommend talking with a manager and stating a case why this is an issue, or why you want to remove it. It might be required...
October 22, 2011 at 1:13 pm
Viewing 15 posts - 14,896 through 14,910 (of 39,824 total)