SQL Server Five methods converting rows to columns(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Five methods converting rows to columns read more...

add a comment |category: Database |Views: 1526

tags: T-SQL SQLServer Database another

SQL Server database settings(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

When creating a new SQL Server database I always use this checklist read more...

add a comment |category: Database |Views: 8

tags: Database another

SQL Server 2000 post upgrade steps(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Small post on additional steps to perform when upgrading from an existing SQL Server 2000 database to SQL Server 2005 / 2008 (after you backup’ed, run upgrade advisor and tested everything twice right!) After a successful restore or attach database operation, execute the following commands in the new environment: read more...

add a comment |category: Database |Views: 8

tags: Database another

SQL Server disk configuration tips(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Most important metrics for SQL Server: ‘throughput’: how many MB/s can the disks handle and what is the load placed on the disks. If you’re buying a standard package your vendor should know this. Surprisingly however in the hardware proposal (top end server(s) / high rpm disks right?) this figure isn’t mentioned anywhere in most situations. read more...

add a comment |category: Database |Views: 11

tags: Database another

How to configure SQL Server TempDB(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

post on SQL Server TempDB best practices read more...

2 comments |category: Database |Views: 9

tags: Database another

Backup the mssqlsystemresource database(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Since the introduction of SQL Server 2005, Microsoft implemented the mssqlsystemresource database read more...

add a comment |category: Database |Views: 13

tags: Database another

Do you have a datetime 'BETWEEN AND' bug?? (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

In SQL Server working with date/time values can be tricky read more...

add a comment |category: Database |Views: 15

tags: Database another

Tools for performance(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Since the introduction of SQL Server 2005 Microsoft implemented Dynamic Management Views (DMV’s) in the database engine that enable us to peek inside of it, and retrieve the internal –performance- counters. The queries described here, combined with my previous posts on fn_virtualfilestats, auto index management, STATISTICS IO, multiple files per database and index reorganization should supply you with enough info to tackle most of I/O related performance issues. read more...

add a comment |category: Database |Views: 10

tags: Database another

SET STATISTICS IO ON(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

The graphical query plans introduced in the latest SQL Server versions give you great inside info on how your query is executing. Downside: sometimes they are difficult to read and they take time to fully understand. Enter: SET STATISTICS IO ON read more...

add a comment |category: Database |Views: 13

tags: Database another

Let SQL Server automatically suggest indexes!(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 3 months ago

I found this link on the Microsoft website Making use of Dynamic Management Views (DMV) they analyze for all databases/tables and make suggestions about index usage read more...

add a comment |category: Database |Views: 11

tags: Database another

Enable those alerts!(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 3 months ago

Since SQL Server 7.0 Microsoft has implemented so called alerts in SQL Agent. The main purpose of these alerts is that when specific events occur, the DBA automatically gets informed by mail / pager or other means of these event(s) and take corrective action. read more...

add a comment |category: Database |Views: 5

tags: Database another

SQL Server Day to day maintenance(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 3 months ago

Here’s a little SQL Server T-SQL script I wrote that will executes some day-to-day maintenance It’ calls some sp’s in MSDB to remove old (as specified by the parameter in the dateadd() function) mail, job and backup history info that will normally accumulate in msdb making it grow bigger over time. Also a DBCC CHECKDB statement read more...

add a comment |category: Database |Views: 8

tags: Database another