Viewing 15 posts - 32,176 through 32,190 (of 39,748 total)
It's been awhile, but I think this has something to do with security. Either your user or the SQL Server user do not have administrative rights needed for debugging.
April 30, 2007 at 12:21 pm
Everything in the index plan should add up to 100%, so there will always be things with large percentages. Seeks are better than scans because you're traversing the index directly...
April 30, 2007 at 12:20 pm
I thought there was plenty of time, but I am a fast reader.
This exam is a "case study" exam. Each "part" is a case study, maybe a page to a...
April 30, 2007 at 6:39 am
Lots of differences and really two many to list. SS2K5 is a whole new animal and an upgrade should bring along your jobs.
April 30, 2007 at 6:37 am
Works fine here and as far as I know, it's supported. Now SQL 2005 wasn't supported on Vista before SQL SP2.
April 30, 2007 at 6:36 am
There is no limit on a table created at runtime for size. I'd guess that you might exceed the disk space for the file and cause a growth, which in...
April 30, 2007 at 6:35 am
Use Profiler. Track the SPID of the user with sp_who and use that as a filter in Profiler.
April 30, 2007 at 6:34 am
In SQL, there is no ordering to records, so in order to get the top 10, you need to specify some order, as Peter mentioned.
Is it top 10 by name,...
April 29, 2007 at 9:19 am
Very intersting questions. I'd try to experiment and with dbcc page or even add data to a new table in 2k chunks and see how many pages are used.
My suspicion...
April 29, 2007 at 9:07 am
Thanks for the notes and I'd hope things are ok if I miss a newsletter. It's happened before, so I'd like to think so.
I definitely wasn't prepared for work, and...
April 28, 2007 at 9:36 am
Partitioning should help, though be sure you separate out the IO or move to a new server to help with the load. If you can handle some of the stuff...
April 26, 2007 at 12:19 pm
David,
Can you explain to a not-so-smart guy on where/why you'd want this language? I'm not quite following the problems it solves, or maybe I just don't understand what you think...
April 26, 2007 at 12:17 pm
You can't "upgrade", but you can detach the dbs from personal and attach to Standard. As mentioned above, install only Standard on the new server.
April 26, 2007 at 12:14 pm
Viewing 15 posts - 32,176 through 32,190 (of 39,748 total)