-
Stored procedure to monitor long-running jobs in SQL Server 2000
Monitoring long-running jobs in SQL Server 2000 is not a simple practice, but it is a best practice among DBAs. In this tip, try out a stored procedure that easily identifies long-running jobs. You...27 Feb 2008
-
Create an upgrade plan for your move to SQL Server 2005
The best way to move from SQL Server 2000 to SQL Server 2005 is to map it out in phases. Here's a project plan with key points to consider at each upgrade phase, such as differences in print statem...25 Feb 2008
-
Using BULK INSERT to insert rows from SQL Server dataset to table
Learn how to use BULK INSERT to import all SQL Server dataset rows to a table.20 Feb 2008
-
What is the code to restore SQL Server databases in VB?
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.20 Feb 2008
-
How can I export stored procedures in SQL Server 2005?
Export stored procedures in SQL Server 2005 with these step-by-step instructions in SQL Server Management Studio.20 Feb 2008
-
SQL Server query to import database names
Discover a query that will import all database names into your SQL Server.20 Feb 2008
-
Workaround to Reporting Services error in SQL Server Express
Discover a SQL Server workaround to fix an error that pops up when trying to view a report in the Report Manager when using Reporting Services in SQL Server Express.20 Feb 2008
-
Troubleshoot SQL Server 2005 SP2 installation error
Learn to troubleshoot an error that occurs when running the Service Pack 2 install for SQL Server 2005 that claims the account is not able to rename a file.20 Feb 2008
-
Five sqlcmd features to automate SQL Server database tasks
Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcm...18 Feb 2008
-
Designing SQL Server non-clustered indexes for query optimization
Non-clustered indexes improve SQL Server query performance by focusing queries on a subset of data. In this tip, you'll find guidelines for designing non-clustered indexes, including choosing index...13 Feb 2008
-
Simplify queries with SQL Server 2005 common table expressions (CTEs)
Common table expressions (CTEs) are a handy alternative to using derived tables and views in SQL Server 2005 for retrieving data. There's no need to repeat complex code because CTEs separate code i...13 Feb 2008
-
Configuring SQL Server memory settings
While SQL Server has only a few simple memory settings, those settings are crucial. In this tip, SQL Server expert Denny Cherry shares configuration recommendations for optimal RAM amounts, how to ...11 Feb 2008
-
Get your SQL Server security goals in order
Establishing SQL Server database security goals is only half the battle. Whether it's patching SQL Servers or setting long-term goals, such as periodic database security assessments, a plan must be...06 Feb 2008
-
Stored procedure for a BULK INSERT to SQL Server 2005 text file
Discover a stored procedure using the BULK INSERT command to import multiple tables to a SQL Server 2005 text file.06 Feb 2008
-
Tricking SQL Server into making full database backups
VistaPrint, a company with site databases containing more than 2 terabytes of data employed a third-party tool to log ship from its Bermuda SQL Servers to standby SQL Servers in Massachusetts. The ...05 Feb 2008
-
Optimize SAN setup for improved SQL Server performance
Maybe you're already using SANs in your SQL Server environment, but is it the optimal setup? Consider these pointers for a disk system design that yields a high performing and scalable SQL Server e...01 Feb 2008