Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.
2003-08-20
9,789 reads
2003-08-18
2,303 reads
Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!
2007-10-01 (first published: 2003-08-13)
54,013 reads
SQL Scripter is a tool for SQL Server 7.0/2000 database administrators and developers to script data in a valid T-SQL format which can be executed in Query Analyzer. All types are supported (INSERT, UPDATE, DELETE). It's free in the moment. (Not Reviewed)
2003-08-13
1,259 reads
2003-08-08
2,564 reads
2003-08-06
2,366 reads
2003-08-04
3,101 reads
Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.
2003-08-01
15,768 reads
2003-07-31
2,421 reads
2003-07-30
1,961 reads
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Affiliate marketing has become a popular way for businesses to expand their reach and...
Comments posted to this topic are about the item Insiders Selling Data
Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...