Viewing 15 posts - 17,491 through 17,505 (of 22,202 total)
I've looked through the query, but I haven't read all of it (there's a lot going on there). In general, your queries seem to be structured generally OK (the one's...
May 8, 2009 at 9:38 am
Sounds like a one to many relationship.
Use the primary key of the main table that links to X number of rows in the second table. So for your array sitation:
MainTable
MainTableId...
May 8, 2009 at 8:52 am
To my knowledge... No, this won't change performance. Let's also add a clustered index to the table. Assuming it's the same clustered index before and after the alter, all the...
May 8, 2009 at 8:46 am
How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks... not at...
May 8, 2009 at 8:40 am
Just hit the microsoft documentation. There's tons of information available there.
May 8, 2009 at 8:37 am
The error is very straight forward. You've got duplicate data. The key is to identify what constraints you have and then break down the procedure and capture the data output...
May 8, 2009 at 8:36 am
To eliminate the key lookups you need to make the non-clustered indexes into covering indexes by either adding columns needed to the key or as included columns. But you need...
May 8, 2009 at 8:33 am
Only use nvarchar if you are absolutely going to be using the extended character sets. If you're just using some of the ascii characters with umlauts or whatever, you just...
May 8, 2009 at 8:01 am
I'm 46 and I think I'm going to try being a geek forever. I'm just not the management type and I really like playing with toys. I know an MS...
May 8, 2009 at 6:15 am
Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm...
May 7, 2009 at 6:24 am
What about good?
What about evil?
What about right?
What about wrong?
Is there a Vorlon in the building?
May 7, 2009 at 6:13 am
Profiler would be my first choice.
Second wouldn't be sp_who2. It'd be sys.dm_exec_requests. With that you can link to other dmv's to get query text, execution plans... whatever you need. But,...
May 7, 2009 at 6:08 am
To heck with google. Open up Books Online. A lot of, most, of the information you need is in there. You don't need to go googling until or unless you...
May 7, 2009 at 6:05 am
Nice job Sylvia,
When you kick up this much mud, you did well.
I do need to disagree with you though. Picking and choosing when to alias or when not to leads...
May 7, 2009 at 5:50 am
Viewing 15 posts - 17,491 through 17,505 (of 22,202 total)