Skip to content

Main Navigation

Just A ThoughtBytes and Bites of Internet

Archives

Tags

.NETASP.NETBabblingBlogBugBugsDatabaseDOSEventExpression BlendFirefoxGoogleHow ToHTMLIISInstallerLinuxMeMicrosoftMigrationNewsOraclePerformance TuningPowerShellReportingReviewServerSharePointSilverlightSoftwareSQL ServerSSISSSRSSubversionThoughtTipsToolsTortoiseSVNTripsTSQLUbuntuVirtualizationVisual StudioWindowsWordpress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Category: SQL Server

Page level recovery in SQL Server 2012

July 8, 2012 (July 7, 2012) Gaurang

Database corruption can be difficult to detect and sometimes it is very possible that you might not even notice it until you run DBCC command on your database to check logical and physical consistency of that database. It is very common practice to run DBCC CHECKDB without any additional options at regular intervals to make […]

SQL Server, TipsSQL Server, Tips Leave a comment

Issue with Backup sets of Backup in SSMS 2012

April 19, 2012 (April 19, 2012) Gaurang

Just like many fellow early adopters, me too have installed shiny new SQL Server 2012 in my work machine. And I have been using it quite a while. Since it is “Powered by Visual Studio” now it has look and feel of VS 2010 too (for me main reason was included support of BIDS … […]

Bugs, SQL ServerBug, SQL Server Leave a comment

Adventureworks in SQL 2012

April 1, 2012 (March 31, 2012) Gaurang

After trying different RCs, finally this weekend I got time to download SQL 2012 rtm dev edition from my dreamspark account. And my first decision was to get some test dbs with some nice data. And choice was pretty simple, use Adventureworks sample databases from CodePlex. But with a bit of surprise, they don’t have […]

SQL Server, TipsSQL Server, Tips Leave a comment

Isolation levels in SQL Server … part II

January 8, 2012 Gaurang

In previous post I explained basics of ISOLATION levels in general. This post is a sort of demo of isolation levels in SQL Server. In SQL Server, Isolation property can be configured using “SET ISOLATION” command. This command can be used to set isolation at any given transaction. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO […]

Database, SQL ServerDatabase, SQL Server Leave a comment

Isolation levels in SQL Server … part I

January 7, 2012 Gaurang

Just like any reliable transaction system, SQL Server supports ACID properties. If you have never heard of ACID properties before than it is actually set of four properties Atomicity, Consistency, Isolation and Durability. These set of properties makes sure that what ever transaction we do in SQL Server (or any DBMS) and database performs consistently […]

Database, SQL ServerDatabase, SQL Server Leave a comment

Resolving … Agent XPs disabled issue in SQL Server 2005

December 27, 2011 Gaurang

SQL Server sometimes behaves very strangely for no apparent reason. Few days back I was playing with our staging server and I had to stop SQL Server service for some testing purposes. When I started it back, I saw that SQL Server Agent was disabled and next to it a message showing that “Agent XPs […]

Bugs, SQL ServerBug, SQL Server Leave a comment

“EXECUTE AS” clause in T-SQL

December 15, 2011 Gaurang

In T-SQL there is really interesting clause available which allows DB engine to execute some particular module (function, SP, trigger etc) with context to some user. This clause is very handy when we don’t want some specific user to have access to some schema but we still want that user to allow access to data […]

SQL Server, TipsSQL Server, Tips Leave a comment

Posts navigation

  • ❮
  • 1
  • 2
  • 3
  • 4
  • …
  • 8
  • ❯
Copyright ©2021 Just A Thought : Bytes and Bites of Internet. Theme: Simple News by IndoCreativeMedia.