-
Use table-valued parameters for SPs in SQL Server 2008
Pass variables as parameters in your stored procedure and save time by making significantly fewer calls to SQL Server and fewer writes against the database.
-
Update table statistics in SQL Server for performance k
Here's what you need to know about using auto and manual update commands and avoiding false statistics -- two of many techniques that will fine-tune SQL Server statistics and boost performance and ...
-
Mirrored backup and restore commands in SQL Server 2005
Mirrored backups in SQL Server provide an extra layer of data protection. Learn how mirrored backup commands work with media sets ("media family") to minimize data loss. You'll also see how to rest...
-
Creating SQL Server columns: A best practices guide
When creating SQL Server columns, improve database performance by following these best practices for defining data types, keys and NULL configurations.
-
Creating SQL Server tables: A best practices guide
When creating SQL Server tables, follow these quick tips for defining filegroups, indexes, key constraints and partitions to improve SQL Server performance.
-
Creating SQL Server tables and columns: Quick tips to k
Performance of a SQL Server table can depend on how you've defined data types, indexes, partitions and other components. Use this best practices guide when creating tables and columns for large dat...
-
Optimize tempdb in SQL Server by striping and splitting
Optimize tempdb performance by striping and splitting to multiple files. Here are some pointers to effectively allocate temporary databases across filegroups in SQL Server 2005.
-
Best practices for SQL Server backup maintenance
Improve SQL Server performance by removing backup history from the msdb database and reducing its size. Database architect Denny Cherry shares some backup commands for optimal SQL Server maintenance.
-
SQL Server 2005 permissions capabilities
In SQL Server 2005, more permissions can be given at both the instance and database level, compared to previous releases. Permissions can also now be inherited. Here are some examples to illustrate...
-
Database security testing terms: Setting the record str
There are differences among three commonly used database security testing terms. IT security specialist Kevin Beaver shares the characteristics that set apart security audits, penetration tests and...
-
Problem connecting to SQL Server 2000 Analysis Services
Have a problem connecting to SQL Server 2000 Analysis Services? SQL Server expert Michelle Gutzait examines possible problems and ultimately shares a solution. Hint: It could be your memory settings.
-
Handle slowly changing dimensions with SSIS 2005 wizard
Managing slowly changing dimensions in SQL Server 2005 can be as easy as a few clicks for a data warehouse architect. Here are steps to run the Slowly Changing Dimensions Wizard in SQL Server Integ...
-
SQL Server blob data types for accessing and storing da
When storing blob data, you can choose from various data types. In this tip, SQL Server architect Denny Cherry examines each data type and explains how to store and access the blob data.
-
Run DTS packages within SQL Server Integration Services
Do you have a DTS package that performs just right in SQL Server 2000 and you'd like to have it do the same in SQL Server 2005? A method does exist. SQL Server expert Eric Johnson walks you through...
-
Simplify SQL Server replication
You can simplify SQL Server replication management and monitoring with advice from SQL Server expert Michelle Gutzait. She shows you how to reduce the number of publications and subscribers for imp...
-
Managing permissions in SQL Server Reporting Services
SQL Server Reporting Services offers ease when creating and deploying SQL Server reports for your entire organization. But when it comes to SSRS security, there's some work to be done on your part.
-
Examples of SQL Server stored procedures and parameters
How can SQL Server stored procedures be helpful if you don't know they exist? Database architect Denny Cherry shares 18 examples of handy stored procedures and their parameters that Microsoft has n...
-
SQL Server 2005 Express: Beyond the basics
It might be a scaled down version of SQL Server, but SQL Server 2005 Express Edition delivers advanced performance. Windows expert Serdar Yegulalp explains how, including using it in custom applica...
-
SQL Server 2005 Express vs. Desktop Engine (MSDE)
SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) each provides a medium where database administrators can work before leaping to the full version of SQL Server. Windows expe...
-
Best SQL Server indexing strategies
SQL Server supports only two index types for most data types: clustered and non-clustered. Learn how and why building the appropriate index type during your database design will significantly impac...
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
SQL Server meets database application security
Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.