This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Generate Scripts.

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 Tips and Tricks
SQL Scripts, SQL Utility

Use the SQL Server script generator wizard to copy database schema, data and all objects, then run the large script with SQLCMD on the new instance.

Read More
A rich ceramic inspection table compares intact glazed samples with one visibly cracked sample under a brass loupe.

SQL Assessment API Findings: From Scan to Action

May 6, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, PowerShell, SQL Server, SQL Server Configuration

SQL Assessment API findings can guide a health review, provided the scan’s scope and evidence are clear. I separate collection problems from recommendations before deciding what to change. A short list is useful only when I know what was checked.

Read More
A detailed inspection bench holds a carefully organized tool tray beside a wooden assembly ready for checking.

SQL Server Health Check: Six Checks to Prioritize

May 5, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Backup and Restore, SQL Server, SQL Server Configuration, SQL TempDB

A SQL Server health check becomes useful when its findings lead to a clear, justified next step. I start with recovery and access risks before tuning preferences. A warning deserves investigation, but it does not automatically justify a server change.

Read More
A row of mugs on kitchen hooks, one mug per hook, except one hook holding two mugs together.

ROWS vs RANGE in Window Frames: Why Running Totals Differ

May 4, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Order By, SQL Scripts, SQL Server

Compare ROWS vs RANGE for running totals, handle tied sort values, write explicit frames, and check worktable reads on your server.

Read More
A grain silo with its main doors blocked by spilled grain and a small side hatch open with a lantern inside.

Diagnosing a Frozen Server With the Dedicated Admin Connection

May 4, 2011
Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL Server Configuration, sqlcmd

The dedicated admin connection provides a narrow emergency path to a stalled SQL Server; prepare remote access and keep diagnostics light.

Read More
Gouache painting: in a sports room, two identical pegged racks hold the same four team bibs in cream, blue, sage and red

XML sql:column: Compare XML With a Relational Value

May 3, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

XML sql:column passes a typed relational value into XQuery. Keep node existence separate from a missing document and a scalar Boolean.

Read More
Execution Plan for SQL Query.

SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012

May 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

How fast are result sets in SQL Server 2012 compared with a temp table? I ran both methods and compared their execution plans to answer a reader.

Read More
Two storks with red beaks rearranging sticks in a new nest on top of a village chimney

Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences

May 1, 2011
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Identity, SQL Migration, SQL Server

Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.

Read More
A table top used as a template, traced in pencil onto a fresh sheet of plywood on trestles.

SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?

April 30, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Table Operation

CTAS stands for Create Table As Select. In SQL Server you do it with SELECT INTO, which creates the new table and fills it with data in one step.

Read More
SQL SERVER - 2012 - Executing Stored Procedure with Result Sets - New

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New

April 29, 2011
Pinal Dave
SQL Tips and Tricks

Executing stored procedure with result sets works for multiple resultsets too. WITH RESULT SETS handles them easily, while the old temp table method cannot.

Read More
Previous 1 … 419 420 421 422 423 424 425 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com