SQL Tips and Tricks Archives - Page 319 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Common Table Expression (CTE) and Few Observation

May 10, 2011

This blog post is written in response to the T-SQL Tuesday hosted by Bob Pusateri. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…

SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007

May 9, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…

SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?

May 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently I was talking with Vinod Kumar regarding NOLOCK. Suddenly he asked me do I know what kind of lock WITH(NOLOCK) hint takes on object. The immediate response of mine was that NOLOCK does not take any lock. He responded suggesting that I should think more and answer. I realized…

SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

May 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Quite often I get the request regarding how to copy all the objects – including schema and data from any database and re-create it on another instance. SQL Server 2008 and SQL Server 2008 R2 has script generator wizard which does it for us. I ask you to pay special…

SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

May 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

Yesterday I presented on the subject Check SQL Server Health using Best Practices Analyzer. There was great response to the session. Many asked me if the session is recorded so they can watch it later on. Absolutely, the session is recorded and you can watch it at your convince. Not…

SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

May 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Today (May 5, 2011) I will be presenting on Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer at . I will be presenting on following subjects. The tools which I will be using in the demonstration are following: Engine – Backups outdated for databases Engine – Database files and…

SQL SERVER – Cartoon Challenge – 140 Character Winner is Here

May 4, 2011

Pinal Dave

Personal, SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

Database, MVP, SQL Scripts

Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…