Viewing 15 posts - 4,876 through 4,890 (of 14,953 total)
Definitely avoid the view whenever possible.
Views are just pre-defined select statements. That kind of view, with lots of tables and (I'm guessing) tons of columns, will kill performance if...
February 22, 2011 at 11:35 am
Make it an "identity" column.
February 22, 2011 at 11:32 am
I wrote some articles on audit logs a while back. They might help:
February 22, 2011 at 11:01 am
One of the "tables" is probably actually a view, or one of them has a computed column that references a view or UDF. That's where you'll find the linked...
February 22, 2011 at 10:59 am
Something like:
select 'drop user ' + name + ';'
from sys.database_principals
WHERE type = 's';
Copy-and-paste the results into a window in Management Studio, delete the ones you want to keep, and then...
February 22, 2011 at 8:46 am
You should probably consider a unique index on username (honestly, I'd make that the primary key and cluster on it).
As a side note, you might want to consider using a...
February 21, 2011 at 3:40 pm
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
February 21, 2011 at 3:38 pm
chrisn-585491 (2/21/2011)
To me, being able to intelligently anticipate and answer questions about "the next version of the primary tool of my trade" is part of what I'm being paid for....
February 21, 2011 at 3:36 pm
xp_cmdshell has a "no_output" option. Use that.
February 21, 2011 at 2:22 pm
Jeff Moden (2/21/2011)
GSquared (2/21/2011)
Dates in SQL Server are stored as numbers. You could easily extend to bigint for...
February 21, 2011 at 2:21 pm
jcrawf02 (2/21/2011)
GSquared (2/21/2011)
Jeff Moden (2/21/2011)
Well...
February 21, 2011 at 2:15 pm
GilaMonster (2/21/2011)
GSquared (2/21/2011)
GilaMonster (2/21/2011)
Jeff Moden (2/21/2011)
February 21, 2011 at 2:06 pm
GilaMonster (2/21/2011)
Jeff Moden (2/21/2011)
Heh... no one even noticed recently... I slipped over the 24,000 post line, Gail topped 22,000 posts, and Gus has put the hammer on 10,000 posts.
Now here's...
February 21, 2011 at 1:37 pm
Jeff Moden (2/21/2011)
Well done, ladies...
February 21, 2011 at 1:37 pm
Viewing 15 posts - 4,876 through 4,890 (of 14,953 total)