Viewing 15 posts - 20,656 through 20,670 (of 22,202 total)
It doesn't answer the question, but you can double click on the line next to the column and it will expand to the full size for you. A tiny bit...
April 11, 2008 at 8:49 am
Books online recommends not placing objects in Master. I'd recommend against it too.
Truth is, you can put objects there. You'll have to be much more careful about backups. You might...
April 11, 2008 at 8:20 am
Do you mean you want a script to generate the table? I ask because sp_help does show you the information about the table that defines it.
You could write up...
April 11, 2008 at 8:09 am
Thanks. I'm glad it was helpful. I originally wrote the thing when it looked like we had a success. I then went back and added new information to portray the...
April 11, 2008 at 7:56 am
The problem is, I'd be telling you how I feel. I have yet to work on a major project using ORM so I can't give you a list of quantifiable...
April 11, 2008 at 6:26 am
I don't think there is.
April 11, 2008 at 6:23 am
If "most" of your queries require DISTINCT or GROUP BY to eliminate duplicates then, in general terms, you're writing your queries incorrectly or the data design is wrong. While there...
April 11, 2008 at 6:16 am
I have to agree. 2 is fine. 1 & 3 are silly limitations. If you're going with pure natural keys, maybe then you never use identity, but if you're just...
April 11, 2008 at 5:50 am
Instead of using the sub-query as part of the select list, make it a derived table, join against it, and you'll get a row for each value in that table.
April 11, 2008 at 5:42 am
We're using them all over the place. It allows us to set up different security management processes within the same database and maintain them very easily since you can grant...
April 11, 2008 at 5:39 am
No, nobody should beat you up. "It depends" is always the right answer. The factors involved really do make a difference. If the system in question is meant to gather...
April 10, 2008 at 8:31 am
Everyone else has already said it, but I can expand a bit. XML is the answer. You want to look at ALL your database processes from the approach of working...
April 10, 2008 at 8:01 am
DonaldW (4/10/2008)
Grant Fritchey (4/9/2008)
What's the difference between a clustered & non-clustered index?
What's the difference between blocking & deadlocking?
How do you trap errors in SQL Server 2005?
What does...
April 10, 2008 at 6:13 am
Our entire enterprise is running on TCP/IP connections (I suspect most are these days). If you can connect to your SQL Server instance and run 'SELECT * FROM SomeTable', then...
April 10, 2008 at 6:06 am
It's possible that it could be as problematic as anything else, but you might try dropping & recreating the index. That will also remove fragmentation. The Storage Engine team at...
April 10, 2008 at 5:57 am
Viewing 15 posts - 20,656 through 20,670 (of 22,202 total)