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
SQL SERVER - Reverse String Word By Word

SQL SERVER – Reverse String Word By Word

December 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.

Read More
Stop SQL Server dialog box.

SQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered

December 5, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

While building a tempdb demo, SQL Server would not start and ERRORLOG showed Error 5161, an unexpected file id was encountered. I explain what caused it.

Read More
OleDb Destination Editor.

SQL SERVER – The Basics of the SSIS Data Flow Task – Notes from the Field #057

December 4, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS

Andy Leonard explains the basics of the SSIS Data Flow Task and how a novice developer can learn SSIS from the beginning.

Read More
SQL SERVER - Beginning with SQL Server Security Aspects

SQL SERVER – Beginning with SQL Server Security Aspects

December 3, 2014
Pinal Dave
SQL Tips and Tricks
Devart, SQL Server Security

A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.

Read More
SQL SERVER - How to Disable and Enable All Constraint for Table and Database

SQL SERVER – How to Disable and Enable All Constraint for Table and Database

December 2, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys

Readers often ask how to disable and enable all constraint for table and database. Here are simple ALTER TABLE scripts for both, plus one for a single constraint.

Read More
A row of stable stalls, most with one pony, a few empty, and one crowded with three ponies.

Hash Index Bucket Count for Memory-Optimized Tables

December 1, 2014
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Index, SQL Memory, SQL Server

Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.

Read More
Temp table query execution plan.

SQL SERVER – Inside Temp table Object Creation – Part II

November 30, 2014
Pinal Dave
SQL Tips and Tricks
Temp Table

A first year developer wrote in with a question after my post on temp table object creation. Here is my answer, with a closer look at tempdb.

Read More
Customization of Query in SQL Server Management Studio.

SQL SERVER – Customization of New Query in SQL Server Management Studio

November 29, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio

A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.

Read More
SQL server missing parameter data types.

SQL SERVER – Identifying T-SQL Missing Parameter Data Types with SQL Server

November 28, 2014
Pinal Dave
SQL Tips and Tricks

A senior developer asked how to catch code from junior developers with wrong or missing parameter data types. SQL Server itself can help you find them.

Read More
SQL Server 2014 RTM and Windows Server 2012 R2.

SQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056

November 27, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Azure, SQL Backup and Restore

Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.

Read More
Previous 1 … 280 281 282 283 284 285 286 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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