Viewing 15 posts - 35,731 through 35,745 (of 39,720 total)
Check the script library here. You can delete from teh tables (not recommended). I believe that there are some things that are limited in history, i.e. maintenance plans and clean...
October 22, 2003 at 3:22 pm
I mean the main PSFT db. How large is that, how many users? Which modules?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 3:53 pm
Interesting. Can you set an alert and capture sp_lock when the deadlock occurs. Might help with determining the answer.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 10:54 am
How big is your PSFT db?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 10:53 am
It's a tough issue because you have to define "up". If the server is running, but someone can't connect to the server (network issue), is the database "up"?
I'd script something...
October 20, 2003 at 10:46 am
Nice summary of items. Personally I usually set parameters to NULL and then check for NULL to display the "you need parameter x" included" message.
I'm wary of external documentation. People...
October 20, 2003 at 10:44 am
Thanks
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:46 am
There isn't a way to do this after the fact. There is no "audit" of tables used or altered, only those that are created.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
October 17, 2003 at 9:45 am
This doesn't really make sense. Are there answers stored somewhere? What's with all the "testxxx" rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:44 am
Not sure about that. In a limited test, it appears I get the same execution plan either way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 10:01 am
Apologies on v7. Not sure how many of them work, but QA was a 1.0 product in 7 and substantially enhanced in 2000.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
October 16, 2003 at 9:44 am
Daily - Backups!! Make sure these work
Weekly - Run dbccs, maint plan helps here. Patches, etc. We have a weekly window available for maint. Don't always take it, but dbccs...
October 16, 2003 at 9:41 am
The only way to really do this is either run Profiler or use Entegra from Lumigent.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 9:34 am
Use character fields
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 9:33 am
Ditto the comment that I'm not sure this really matters to me, but it is interesting to see how SQL deal with space.
I'd be curious to see this graphically, but...
October 16, 2003 at 9:29 am
Viewing 15 posts - 35,731 through 35,745 (of 39,720 total)