Blogs about: Sql Scripts

Featured Blog

SQL SERVER - 2008 - Find If Index is Being Used in Database4 comments

pinaldave wrote 5 days ago: It is very often I get query that how to find if any index is being used in database or not. If any … more →

Tags: technology, SQL Server, SQL Performance, SQL, SQL Query, SQL Tips and Tricks, SQL Index, SQL Authority, Author Pinal

SQL Server - 2008 - Cheat Sheet - One Page PDF Download3 comments

pinaldave wrote 6 days ago: Very frequently I have been asked to create a page, post or article where in one page all the import … more →

Tags: Author Pinal, Best Practices, Database, dba, Software development, SQL, SQL Add-On, SQL Authority, SQL Coding Standards

SQL SERVER - Puzzle - Solution - Computed Columns Datatype Explanation2 comments

pinaldave wrote 1 week ago: Just a day before I wrote article SQL SERVER - Puzzle - Computed Columns Datatype Explanation which … more →

Tags: Author Pinal, Database, SQL, SQL Authority, SQL Documentation, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks

SQL SERVER - Renaming SP is Not Good Idea - Renaming Stored Procedure Does Not Update sys.procedures3 comments

pinaldave wrote 1 week ago: I have written many articles about renaming a tables, columns and procedures SQL SERVER - How to Ren … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T-SQL

SQL SERVER - Puzzle - Computed Columns Datatype Explanation4 comments

pinaldave wrote 1 week ago: Yesterday I wrote post about SQL SERVER - Get Answer in Float When Dividing of Two Integer. I receiv … more →

Tags: Author Pinal, SQL, SQL Authority, SQL Documentation, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Guidelines and Coding Standards Complete List Download3 comments

pinaldave wrote 1 week ago: SQL SERVER - Guidelines and Coding Standards complete List Download Coding standards and guidelines … more →

Tags: Author Pinal, Best Practices, Data Warehousing, Database, dba, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys

SQL SERVER - Guidelines and Coding Standards Part - 27 comments

pinaldave wrote 2 weeks ago: To express apostrophe within a string, nest single quotes (two single quotes). Example: SET @sExam … more →

Tags: Author Pinal, Best Practices, Database, Software development, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Performance

SQL SERVER - Guidelines and Coding Standards Part - 113 comments

pinaldave wrote 2 weeks ago: Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Al … more →

Tags: technology, SQL Joins, SQL Server, SQL Performance, SQL, SQL Query, SQL Stored Procedure, SQL Constraint and Keys, Database

SQL SERVER - 2008 - Interview Questions and Answers Complete List Download6 comments

pinaldave wrote 2 weeks ago: Download SQL Server 2008 Interview Questions and Answers Complete List Interview is very important e … more →

Tags: technology, SQL Joins, SQL Server, SQL Performance, SQL, SQL Query, SQL Error Messages, SQL Stored Procedure, SQL Cursor

SQL SERVER - 2008 - Interview Questions and Answers - Part 81 comment

pinaldave wrote 2 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download What is Data Compression? … more →

Tags: technology, SQL Server, SQL, SQL Query, Database, Main, SQL Function, SQL Tips and Tricks, SQL Index

SQL SERVER - 2008 - Interview Questions and Answers - Part 7

pinaldave wrote 2 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download How can we rewrite sub-qu … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Error Messages, Database, Main, SQL Tips and Tricks, SQL Authority

SQL SERVER - 2008 - Interview Questions and Answers - Part 6

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 3) Questions of SQL SERVE … more →

Tags: technology, SQL Server, SQL, SQL Query, Database, Main, SQL Function, SQL Tips and Tricks, SQL Index

SQL SERVER - 2008 - Interview Questions and Answers - Part 5

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download What command do we use to … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Stored Procedure, Database, SQL Tips and Tricks, SQL Authority, Author Pinal

SQL SERVER - 2008 - Interview Questions and Answers - Part 44 comments

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Stored Procedure, SQL Constraint and Keys, Database, SQL Function, SQL Tips and Tricks

SQL SERVER - 2008 - Interview Questions and Answers - Part 33 comments

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Constraint and Keys, Database, Main, SQL Tips and Tricks, SQL Index

SQL SERVER - 2008 - Interview Questions and Answers - Part 28 comments

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →

Tags: technology, SQL Joins, SQL Server, SQL, SQL Query, SQL Stored Procedure, SQL Cursor, SQL Constraint and Keys, SQL Function

SQL SERVER - 2008 - Interview Questions and Answers - Part 13 comments

pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Stored Procedure, SQL Constraint and Keys, Database, Main, SQL Tips and Tricks

SQL SERVER - 2008 - Creating Primary Key, Foreign Key and Default Constraint3 comments

pinaldave wrote 1 month ago: Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considere … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Constraint and Keys, SQL Tips and Tricks, SQL Authority, Author Pinal, T-SQL

The My Lord inward-bound Trotskyite...

allegrablythe wrote 1 month ago: Amaya’s thin has a tant soit peu Boeotian ingoing the bluffing shut in that ourselves fill thr … more →

Tags: Poem, living life, bird watching


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS

Find other items tagged with “sql-scripts”:
Technorati Del.icio.us IceRocket