Skip to content
May 19, 2022
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
  • Support SSG
Main Menu

SQL Server Accidental DBA Series

SQL Server Accidental/Involuntary/Junior DBAs Series

SQL Server / SQL Server Accidental DBA Series

SQL Server new query window shortcut

April 15, 2015December 20, 2019 - by SQL Geek - 1 Comment

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 More
SQL Server / SQL Server Accidental DBA Series

SQL Server error message 3159

April 12, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

SQL function to get weekday – weekly calendar

April 10, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Insert multiple rows using single Insert statement in SQL Server

April 7, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Constraint to limit VARCHAR max character length in SQL Server

April 4, 2015December 20, 2019 - by SQL Geek - 1 Comment

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 More
SQL Server / SQL Server Accidental DBA Series

SQL Server unattended installation 2014

March 30, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Primary Key and Unique Key difference in SQL Server

March 27, 2015December 20, 2019 - by SQL Geek - 1 Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Locking hints SQL Server

March 25, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Difference between UNION and UNION ALL in SQL Server

March 22, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Detach or take offline in SQL Server

March 19, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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

Posts navigation

1 2 … 12 Next

Subscribe to SQLServerGeeks

Ad

Virtual Symposium

master classes

SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Virtual Symposium

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.