sqlserveradvisor

Stories submitted by sqlserveradvisor

By using some simple T-SQL code, you can compare (all) tables(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisorsqlserveradvisor(385) 2 years, 10 months ago

By using some simple T-SQL code, you can compare (all) tables from different databases read more...

add a comment |category: |Views: 16

tags: another

T-SQL script that uses tablediff to compare all database tables (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisorsqlserveradvisor(385) 2 years, 10 months ago

T-SQL script that uses the tablediff.exe tool to compare all tables from different databases read more...

add a comment |category: |Views: 139

tags: another

How to use SQL Server T-SQL cursors (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisorsqlserveradvisor(385) 3 years, 1 month ago

The general advice within the SQL Server community is do not use any T-SQL cursors at any time. I must say that I have to agree, although if you have browsed my blog you've noticed that there are a couple of occasions when I do use cursors but only when the following is true: read more...

add a comment |category: |Views: 6

tags: another

Working with SQL Server TempDB objects (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisorsqlserveradvisor(385) 3 years, 1 month ago

Some tips on how to use SQL Server TempDB objects read more...

add a comment |category: |Views: 15

tags: another

Why you should or shouldn't want to use AWE(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisorsqlserveradvisor(385) 3 years, 1 month ago

AWE according to BOL: SQL Server 2005 Enterprise Edition supports Address Windowing Extensions (AWE) allowing use of physical memory over 4 gigabytes (GB) on 32-bit versions of Microsoft Windows operating systems. Up to 64 GB of physical memory is supported. My advice: read more...

add a comment |category: |Views: 4

tags: another

Always run SQLIO on new servers! (sqlserveradvisor.blogspot.com)

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

When your vendor brings new types of servers on the market always check if the hardware is as good as they claim it is. read more...

add a comment |category: |Views: 11

tags: another

How many instances on a SQL Server?(sqlserveradvisor.blogspot.com)

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

In my opinion easy and short answer: read more...

add a comment |category: |Views: 13

tags: another

Generate restore scripts from backup history (sqlserveradvisor.blogspot.com)

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

Over the years I’ found this to be a very hand stored proc to generate the required SQL Server T-SQL RESTORE commands to recreate a recovered database out of the latest backup info: dumps to disk (full/differerential/log) and the history tables from MSDB read more...

add a comment |category: |Views: 17

tags: another

Code for all sorts off backup (sqlserveradvisor.blogspot.com)

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

Backup is one off the most important things that need to be arranged after a SQL Server database is created, restored or attached. read more...

add a comment |category: |Views: 5

tags: another

Create multiple files per database and increase performance(sqlserveradvisor.blogspot.com)

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

In this post I want to explain why to create multiple data files per SQL Server database read more...

add a comment |category: |Views: 17

tags: another

(re) Cycle the error logs (sqlserveradvisor.blogspot.com)

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

During my SQL Server career I’ve seen many sites where recycling the error-log(s) was not in place, making browsing of the log from very cumbersome to almost impossible due the large amount of history data that has become meaningless over time. read more...

add a comment |category: |Views: 2

tags: another

fn_virtualfilestats: Measure the I/O load on your disk system (sqlserveradvisor.blogspot.com)

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

Microsoft included the fn_virtualfilestats function in SQL Server so you can monitor the I/O load the instance executes on the disk subsystem. read more...

add a comment |category: |Views: 33

tags: another

Linked (SQL)Server collation, performance and temp tables(sqlserveradvisor.blogspot.com)

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

When I create a linked server to a non SQL Server platform or to a SQL Server instance that's using another collation I always use the following linked server options: read more...

add a comment |category: |Views: 13

tags: another

SQL Server MSDTC settings(sqlserveradvisor.blogspot.com)

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

During installation of a new Windows OS I set the following properties for the MSDTC security settings and transaction timeout. Required when you want to configure and use linked servers read more...

add a comment |category: |Views: 41

tags: another

SQL Server Enable Instant File Initialization(sqlserveradvisor.blogspot.com)

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

In SQL Server 2005 (and higher versions), data files can be initialized instantaneously. Instant file initialization reclaims used disk space without filling that space with zeros. Instead, disk content is overwritten as new data is written to the files... read more...

add a comment |category: |Views: 32

tags: another

SQL Server Windows OS Settings(sqlserveradvisor.blogspot.com)

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

SQL Server Windows OS Settings best practices read more...

add a comment |category: |Views: 11

tags: another