SQL Scripts Archives - Page 260 of 318 - SQL Authority with Pinal Dave

SQL SERVER – DISABLE and ENABLE user SA

December 24, 2008

Just a day ago, I received question from blog reader Mike McDonald. “How can I modify permissions for SA user? I tried to modify dbo users permission but now I am having problems.” First of all, there may be no relation between dbo user and SA user. They are different…

SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL

December 22, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Agent

I often receive a good question on the blog, however, I do not always receive a good answer for the questions. Recently someone asked on a blog about Finding next run time for Schedule Job using T-SQL. My friend came up with a nice script. I have modified it a bit to adjust needs. This blog post is about finding the next running time of scheduled job using T-SQL.

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008

Pinal Dave

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

SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…

SQL SERVER – Interesting Interview Questions – Revisited

December 17, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, Software Development, SQL Scripts

I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users…

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Collation, SQL Scripts, SQL Server Management Studio

Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explanatory so I will not explain…

SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle

December 13, 2008

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Sub Query

Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run…

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution

December 11, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…