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

SQL SERVER – T-SQL Script to Devide One Column into Two Column

May 25, 2008

Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written. Following is…

SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description

May 24, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Jobs

I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates. SQL Server Interview Questions and Answers Complete List Download Find Job Related to SQL SERVER SQL Server DBA- Job…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2

May 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

I have written article about SQL SERVER – UDF – Get the Day of the Week Function. I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week. CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS…

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.

SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance

May 21, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…

SQL SERVER – 2008 – Choosing the Right Edition for Your Needs

May 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Enterprise SQL Server 2008 is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. Standard SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications. Workgroup Run…

SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks

May 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Data Warehousing, Database, DBA, Software Development, SQL Server Security

Note : Download PPT by Microsoft Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices – from platform and network security to incident management – in providing security for web applications and infrastructure. Organizations across the globe face…