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
Service Logon Failure (ObjectExplorer) dialog box.

SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)

May 18, 2011
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Service Logon Failure (ObjectExplorer) stopped my SQL Server Agent from starting. My password had changed, so updating it in the service fixed it.

Read More
A rich locksmith bench separates distinctive brass keys from removable ceramic labels.

External Profiles: Keep Email Out of the Key

May 17, 2011
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

External profiles need a stable scoped identity key. Keep mutable email values separate and reject duplicate identities.

Read More
Three ceramic bowls hold wooden sticks beside a loose pile on an ochre workbench.

Whole Unit Allocation: Keep a Proportional Split Exact

May 14, 2011
Pinal Dave
SQL Tips and Tricks
Mathematical Function, Ranking Functions, SQL Scripts, SQL Server

Whole unit allocation keeps a fixed budget intact. I’d calculate base shares first, then distribute residual units using a stable tie rule. Check equal weights, a zero budget and zero-weight members.

Read More
SQL SERVER - Import CSV File into Database Table Using SSIS

SQL SERVER – Import CSV File into Database Table Using SSIS

May 12, 2011
Pinal Dave
SQL Tips and Tricks
CSV, SQL Scripts, SQL Server, SSIS

How to import CSV file into database table using SSIS, step by step with images, so you can automate the load instead of running Bulk Insert by hand.

Read More
SQL SERVER - Common Table Expression (CTE) and Few Observation

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

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

A few observations on Common Table Expression (CTE): it does not replace temp tables, begin it with a semicolon, and its scope is one statement.

Read More
Sch-S' lock type in a SQL Server execution plan.

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

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

What kind of lock does WITH (NOLOCK) take? Vinod Kumar made me think again: it takes a schema lock, and a quick query on sys.dm_tran_locks proves it.

Read More
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
Previous 1 … 229 230 231 232 233 234 235 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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