Viewing 15 posts - 9,511 through 9,525 (of 9,720 total)
Juan,
I wouldn't wait for the 2008 certs to come out. It'll at least be a year (probably two) before any decent study materials come out. Besides, you get your MCITP...
August 3, 2007 at 4:27 am
You should not try and stop / restart the services until you've tried to kill that particular SPID.
"Kill <spid>" is the command. It may take a while, so be patient. ...
August 3, 2007 at 4:25 am
If you look up "Convert Function" in Books Online, it will give you all the codes for converting a datetime to your proper format. For the Italian format version, the...
August 3, 2007 at 4:19 am
So essentially anything saved to the system that uses a table variable could potentially be listed in sys.indexes as a type "Heap" then.
Hmmm. I suppose that makes sense. Would be...
August 3, 2007 at 3:59 am
I have no idea. And since SPIDs and object_IDs can vary per database, I'm not sure you'll be able to get an answer for that.
But running profiler during the deadlock...
August 2, 2007 at 12:35 pm
I think the author's point was that maintenance used to be simple. Then Microsoft re-wrote the whole thing and made it ten times more difficult in an effort to improve...
August 2, 2007 at 8:18 am
Personally, I think the cost of being civil to your contractor / perspective employer after an interview is far, far less than the cost of not getting the job /...
July 31, 2007 at 12:30 pm
Bob - ROTFLOL.
Steve, here's a non-economic misson critical server for you. The little boxes they use in every tower at every national airport. It's not about money when you lose...
July 31, 2007 at 12:21 pm
Actually, I just discovered that if you run the DBCC command with NoReseed after the original ReSeed command (if there are values in the table), it will reset on the...
July 30, 2007 at 12:42 pm
Opps. I guess I didn't make myself clear.
What I meant to say was that each source can have it's different column count (use the max # of columns you think...
July 30, 2007 at 5:44 am
Dinesh,
What you need is a separate data source for each individual sheet. If the max # is fixed, then you're fine. Just create a source for each possible one and...
July 30, 2007 at 4:08 am
Actually, in my original post, I did provide a better way to do it. And if a variable doesn't work for you, there's always a WHILE LOOP or a UNION...
July 26, 2007 at 8:04 am
RSI? Haven't heard that acronym before.
I hate to say it, but I can see why companies are so resistant to buying ergonomic furniture. First, it's more expensive than the...
July 26, 2007 at 5:41 am
@Thwap! @=)
My predecessor was 6 feet plus some inches tall. The desk and chair were sized for him and I couldn't wrestle the desk loose and reset it by myself. ...
July 26, 2007 at 5:13 am
Virani,
Rather than opening up a backup window from right-clicking the database and choosing "Backup", you should either use the Database maintenance Plan to create and schedule automatic backups or create...
July 26, 2007 at 4:21 am
Viewing 15 posts - 9,511 through 9,525 (of 9,720 total)