June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – 2008 – Step By Step Installation Guide With Images

June 12, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Server, SQL Server Installation

SQL SERVER 2008 Release Candidate 0 has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier.

Read More

SQL SERVER – Order of Conditions in WHERE Clause

June 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

Sr. Developer in my organization asked me the following question about WHERE clause. 

Question: Does the order of conditions matter in WHERE clause?

Read More

SQL SERVER – Compound Assignment Operators – A Simple Example

June 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Server, SQL Utility

SQL SERVER 2008 has introduced new concept of Compound Assignment Operators. Compound Assignment Operators are available in many other programming languages for quite some time. Compound Assignment Operators is operator where variables are operated upon and assigned on the same line.

Read More

SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column

June 4, 2008
Pinal Dave
SQL Tips and Tricks
CSV, Database, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

I received following question in email : How to create a comma delimited list using SELECT clause from table column?

Read More

SQL SERVER – Create Default Constraint Over Table Column

May 31, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

Very frequently Jr. Developers request script for creating default constraint over table column. I have written following small script for creating default constraint. I think this will be useful to many other developers who want this script to keep handy.

Read More

SQL SERVER – PIVOT Table Example

May 22, 2008
Pinal Dave
SQL Tips and Tricks
PIVOT, SQL Scripts, SQL Server, UNPIVOT

This is quite a popular question and I have never wrote about this on my blog. A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.

Read More

SQL SERVER – Ideal TempDB FileGrowth Value

May 17, 2008
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Server, SQL TempDB

Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.

Read More
Previous 1 … 327 328 329 330 331 332 333 … 347 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version