Blogs about: Sql Scripts
Featured Blog
SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char
Today, we will examine something very simple and very generic that can apply to hordes of programming languages. Let’s take a common question that is frequently discussed – What is difference be… more →
Journey to SQL Authority with Pinal Dave
SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char
— 4 comments
pinaldave wrote 3 days ago: Today, we will examine something very simple and very generic that can apply to hordes of programmin … more →
SQL SERVER - Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to 'master'.
pinaldave wrote 1 week ago: I had previously written two articles about an intriguing observation of triggers online. SQL SERVER … more →
SQL SERVER Interview Questions
nagarajreddy321 wrote 2 weeks ago: What is the difference between clustered and a non-clustered index? A clustered index is a special t … more →
SQL SERVER - Performance Counters from System Views - By Kevin Mckenna
pinaldave wrote 3 weeks ago: I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed … more →
SQL Script | Tablespace Threshold value
Monish wrote 3 weeks ago: Use the following script to find out tablespace name under the mentioned threshold value: select tru … more →
SQL Script | Perticular Tablesapce Details
Monish wrote 3 weeks ago: Use the following script is to find out the details of a particular tablespace set lines 999 col fil … more →
SQL SERVER - Create Multiple Filegroup For Single Database
— 3 comments
pinaldave wrote 1 month ago: I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains … more →
SQL SERVER - Difference Between Candidate Keys and Primary Key
pinaldave wrote 1 month ago: Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can … more →
SQL SERVER - Interesting Observation of Logon Trigger On All Servers
— 13 comments
pinaldave wrote 1 month ago: I was recently working on security auditing for one of my clients. In this project, there was a requ … more →
SQL SERVER - Find Hostname and Current Logged In User Name
— 4 comments
pinaldave wrote 1 month ago: I work in an environment wherein I connect to multiple servers across the world. Time and again, my … more →
SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
— 3 comments
pinaldave wrote 1 month ago: Regular readers of my blog are aware of the fact that I have written about this subject umpteen time … more →
SQL SERVER - Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created
— 1 comment
pinaldave wrote 1 month ago: Today, we will delve into a very simple issue that one of the Jr. Developers at my organization conf … more →
SQL SERVER - How to Drop Temp Table - Check Existence of Temp Table
pinaldave wrote 1 month ago: I have received following questions numerous times: “How to check existence of Temp Table in S … more →
SQL SERVER - How to Drop Primary Key Contraint
— 4 comments
pinaldave wrote 1 month ago: One area that always, unfailingly pulls my interest is SQL Server Errors and their solution. I enjoy … more →
SQL SERVER - Questions and Answers with Database Administrators
— 6 comments
pinaldave wrote 1 month ago: I have been in India for long time now, and at present, I am managing a very large outsourcing proje … more →
SQL SERVER - Find Last Date Time Updated for Any Table
— 11 comments
pinaldave wrote 1 month ago: I just received an email from one of my regular readers who is curious to know if there is any way t … more →
SQL SERVER - Roadmap of Microsoft Certifications - SQL Server Certifications
— 3 comments
pinaldave wrote 2 months ago: Introduction In these times of economic slowdown and uncertainties, more and more IT professionals a … more →
SQL SERVER - Add or Remove Identity Property on Column
— 4 comments
pinaldave wrote 2 months ago: This article contribution from one of my favorite SQL Expert Imran Mohammed. He is one man who has l … more →
SQL SERVER - Solution to Puzzle - Shortest Code to Perform SSN Validation
— 3 comments
pinaldave wrote 2 months ago: One of my friends – a SQL Server MVP- Jacob Sebastian has a knack for coming up with interesti … more →
Have your say. Start a blog.
See our free features →
An 
Thingamajig
