Viewing 15 posts - 46,606 through 46,620 (of 49,571 total)
Jeff Moden (5/13/2008)
Heh... can't wait for the mess folks are gonna make in 2k8 with the separate DATE and TIME datatypes...
Agreed. There are legit cases to store just one of...
May 13, 2008 at 12:55 am
Jeff Moden (5/12/2008)
A better question is why would anyone use a character based datatype to store a "Load time"?
And why one would want to store a data and a time...
May 13, 2008 at 12:48 am
Probably because the objects are not fully qualified. (dbo.usp...)
What's probably happening is that SQL's first looking for the object in the current user's default schema, not finding it, then looking...
May 13, 2008 at 12:36 am
Providing there are indexes appropriate for the query, yes
May 13, 2008 at 12:34 am
Run
SELECT @@version
It will say what edition you're running.
From what I recall, the editions are:
Express (free)
Workgroup
Standard
Enterprise
Developer (enterprise features, not for usage in producion system)
May 13, 2008 at 12:31 am
Can you post query, table schema and index definitions please. Can't say anything for sure without seeing those.
May 13, 2008 at 12:27 am
jeff.williams3188 (5/12/2008)
Off the top of my head, I would suspect that you are seeing the checkpoint operation in action.
Sounds very plausable.
At the times that the disk queue length goes up,...
May 13, 2008 at 12:15 am
Paul Fechner (5/12/2008)
How do i attach an sql exec plan for all you experts to review?
As I said above
(saved as a .sqlplan file, zipped and attached to the thread)
If...
May 12, 2008 at 11:56 pm
I'll take a look, but I'm going to need more than 1 row of data. Can you give me data for all the dest airports like 'b%' (the ones you...
May 12, 2008 at 11:53 pm
Table doesn't have a single clustered index. But it have non clustered index on mid.
Will it help to resolve this running total issue ?
Only if the smallest MID was the...
May 12, 2008 at 8:05 am
Does anyone know of any such logging?
Profiler. 🙂
Profiler should be included in workgroup. It's just Express that doesn't have it.
You could also log the sys.dm_exec_requests to a table. Run in...
May 12, 2008 at 7:58 am
You'll get an error if a constraint exists and you try to create another with the same name.
Since they're on Temp Tables and the constraint is dropped when the...
May 12, 2008 at 6:59 am
Probably a different query plan was generated with the clustered index present that required less of the table to be locked.
May 12, 2008 at 6:38 am
Don't name constraints created on temp tables. Object names (including constraint names) must be unique.
When you create a temp table, SQL puts a hash value on the end to...
May 12, 2008 at 6:37 am
I've seen this a number of times, over on http://www.thedailywtf.com 😀
Get out of that company while you still can. That design is one of the things that sounds nice in...
May 12, 2008 at 5:56 am
Viewing 15 posts - 46,606 through 46,620 (of 49,571 total)