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

submitted by sqlserveradvisor(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: Database |Views: 16

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 139

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 6

tags: Database another

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

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

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

add a comment |category: Database |Views: 15

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 4

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 11

tags: Database another

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

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

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

add a comment |category: Database |Views: 13

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 17

tags: SQLServer Database another

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

submitted by sqlserveradvisor(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: Database |Views: 5

tags: SQLServer Database another

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

submitted by sqlserveradvisor(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: Database |Views: 17

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 2

tags: SQLServer Database another

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

submitted by sqlserveradvisor(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: Database |Views: 33

tags: T-SQL SQLServer Database another

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

submitted by sqlserveradvisor(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: Database |Views: 13

tags: Database another

SQL Server MSDTC settings(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(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: Database |Views: 41

tags: Database another

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

submitted by sqlserveradvisor(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: Database |Views: 32

tags: Database another

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

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

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

add a comment |category: Database |Views: 11

tags: Database another