Viewing 15 posts - 8,011 through 8,025 (of 14,953 total)
You posted in the 2005 forum. That's why I assumed 2005.
You could create a trace to track that in the future, but that won't get you answers about the...
October 23, 2009 at 8:29 am
Run a trace on batch completion. Include the database ID and/or name in the trace. Pretty quickly, you'll have data on which databases are used the most, and...
October 23, 2009 at 8:27 am
Personally, I've never seen a value to naming procs with prefixes like that.
I prefer to start their names with the primary table they deal with.
If, for example, I have a...
October 23, 2009 at 8:23 am
Check the schema changes report for the database. That'll have anything that's in the default trace.
If that doesn't go back far enough (sometimes it doesn't go back very far...
October 23, 2009 at 8:14 am
SQL 2005 has a default trace that includes database growth events. Look in there, find out how often the database grows. Most likely, you're getting more than one...
October 23, 2009 at 8:11 am
I'd say you can become a good DBA either way.
The nature of the human mind is to be flexible. It can start out specialized, or it can move that...
October 23, 2009 at 6:49 am
Nah. The connection has properties. Just force the connections string to populate from your variable. It's as easy as right-clicking the connection and going to the right...
October 23, 2009 at 6:44 am
No, Microsoft isn't planning on dumping any of these data types.
One of the things that gets left out of most of these debates is that the CPU does all it's...
October 22, 2009 at 2:37 pm
I've seen both work well. A lot of it has to do with the relative power and load of the two servers. Remote queries can also be quite...
October 22, 2009 at 8:29 am
Are you using DTS or SSIS? (The forum is for SSIS, but you mentioned SQL 2000 data sources, so I need to ask.)
SSIS has a very nice For Each...
October 22, 2009 at 8:24 am
That's simply due to the fact that the software is essentially lazy. The first query, run multiple times, is likely to pull the same data, because both the plan...
October 22, 2009 at 8:21 am
Bob Hovious 24601 (10/22/2009)
When I was a boy, and computers were carved from wood and cranked by hand, it was widely understood that hierarchical...
October 22, 2009 at 8:12 am
ranjitrjha (10/22/2009)
I tried a similar query. I do agree that NOLOCK gives uncommited data but very strangely when I was trying the queries, there was no other user/activity...so i dont...
October 22, 2009 at 7:17 am
Paul White (10/21/2009)
Alvin Ramard (10/21/2009)
Bob Hovious 24601 (10/21/2009)
Sigh... I always over-design things.
Before the XML data type, all data could be stored in tables with a no more than 4 columns....
October 22, 2009 at 7:13 am
You're welcome. Glad I could help.
October 22, 2009 at 7:09 am
Viewing 15 posts - 8,011 through 8,025 (of 14,953 total)