SQL Server new query window shortcut
Shortcuts help you to do your work swiftly and with increased productivity. In this blog we’ll look at new query window shortcut every SQL Server geek should know Shortcut Usage Window …
Read MoreSQL Server Accidental DBA Series
SQL Server Accidental/Involuntary/Junior DBAs Series
SQL Server error message 3159
One of my friends working on SQL Server 2000 to 2005 faced following issue. Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database “databasename” …
Read MoreSQL function to get weekday – weekly calendar
In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly …
Read MoreInsert multiple rows using single Insert statement in SQL Server
This is a very basic problem sometimes newbies struggle with. I have seen developers writing 10 different insert statements to insert 10 rows in a table. This can be simplified in …
Read MoreConstraint to limit VARCHAR max character length in SQL Server
A business need may arise to limit a VARCHAR column to a certain length. Consider a scenario where in an application has a 10000 character limit for a column. The VARCHAR(max) …
Read MoreSQL Server unattended installation 2014
SQL Server unattended installation or silent installation can be done using the configuration.ini file. The SQL Server installation GUI application saves the setup instructions in a configuration.ini file which it further uses …
Read MorePrimary Key and Unique Key difference in SQL Server
Primary and Unique Key both enforce uniqueness of columns on which they are defined. Then where do they differ? They differ in following way – A primary key doesn’t allow null …
Read MoreLocking hints SQL Server
Locking hints are used with SELECT/INSERTS/UPDATE/DELETE statements to enforce or change the default locking behavior. Given below are some of the locking hints available in SQL Server ROWLOCK The ROWLOCK hint …
Read MoreDifference between UNION and UNION ALL in SQL Server
Difference between UNION and UNION ALL is one of the most asked interview question. UNION and UNION ALL both combine result set from two or more queries into single result. The …
Read MoreDetach or take offline in SQL Server
Detach or take offline both causes a database to be inaccessible to users. The difference is that detach deletes database metadata from SQL Server i.e. database file information, status information and …
Read More