SQL Server blogs from beyondrelational.com

Active node name where SQL is running - Chintak Chhapia

Wed, 09 May 2012 08:48:00 GMT

Active node name where SQL is running

Guidelines to configure SQL server on developer box - Chintak Chhapia

Wed, 09 May 2012 01:26:00 GMT

Guidelines to configure SQL server on developer box

How to use Picasa Web Album with Google Data API – Part 3? - Vikash Kumar Singh

Fri, 04 May 2012 00:29:00 GMT

How to use Picasa Web Album with Google Data API – Part 3?

SSIS Fast Parse only supports YYYY-MM-DD, YYYYMMDD for parsing date data - Jason Yousef

Thu, 03 May 2012 17:12:00 GMT

Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD Basic and extended formats for a four-digit year, a two-digit month...

Sum up digits of a number - Madhivanan

Thu, 03 May 2012 09:14:00 GMT

Sum up digits of a number

SQL Server Logical Reads - What's it? - Paresh Prajapati

Thu, 03 May 2012 07:54:00 GMT

SQL Server Logical Reads - What's it?

SQL Server - Secret behind restriction of maximum length of 116 characters for temp table names - Ramireddy

Tue, 01 May 2012 10:31:00 GMT

SQL Server - Secret behind restriction of maximum length of 116 characters for temp table names

#0159-SQL Server-Row Constructors-Triggers process the entire batch at once - Nakul Vachhrajani

Sat, 28 Apr 2012 14:06:00 GMT

#0159-SQL Server-Row Constructors-Triggers process the entire batch at once

How can I define a DEFAULT value in a timestamp and IDENTITY column? - Manas Ranjan Dash

Sat, 28 Apr 2012 12:04:00 GMT

How can I define a DEFAULT value in a timestamp and IDENTITY column?

16 bit apps are not supported in 64 bit windows - Manas Ranjan Dash

Sat, 28 Apr 2012 11:44:00 GMT

16 bit apps are not supported in 64 bit windows

#0158-SQL Server-Returning result sets from triggers - Nakul Vachhrajani

Sat, 28 Apr 2012 06:07:00 GMT

#0158-SQL Server-Returning result sets from triggers

Always see NullReference exception in designer with Silverlight applicacation when create new applcation - Kirti M.Darji

Tue, 24 Apr 2012 13:23:00 GMT

Today I just creating new project on my machine using Visual stidio 2010 with silverlight 4.0 after creating project i got **NullReference exception ...

Getting Started with Web applications development with servlets and JSP - Part 4: Events - Vladimir Djurovic

Fri, 20 Apr 2012 12:57:00 GMT

Getting Started with Web applications development with servlets and JSP - Part 4: Events

Script to create a Foreign key in SQL Server - Paresh Prajapati

Thu, 12 Apr 2012 05:11:00 GMT

Script to create a Foreign key in SQL Server

Delegates in c# - Jalpesh

Thu, 12 Apr 2012 03:54:18 GMT

What is delegate?

Dynamically creating meta tags in asp.net mvc - Jalpesh

Wed, 11 Apr 2012 03:43:56 GMT

This post describes how to Dynamically create meta tags in asp.net mvc

Simple Tips To Speed Up Your SSIS Data Flow - Samuel Vanga

Wed, 11 Apr 2012 00:29:00 GMT

Simple Tips To Speed Up Your SSIS Data Flow

TSQL Challenge 77 – Basic Testing Results - puzzles

Mon, 09 Apr 2012 07:47:00 GMT

The basic testing results of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals is published and you can find it here. ...

One can change the location of the Windows "Desktop" folder - Paras Doshi

Sat, 07 Apr 2012 01:15:00 GMT

Target OS: Windows 7, Windows Vista. I just learned how to change the location from where the Desktop get's it files/folders. The default location is...

Memory configuration in SQL server and break up of memory utilized by SQL server - Nelson John A

Fri, 30 Mar 2012 08:16:00 GMT

Memory configuration in SQL server and break up of memory utilized by SQL server

Create Property in C# .Net - Kirti M.Darji

Wed, 28 Mar 2012 13:09:00 GMT

Create Property in C# .Net

Multi server Query with Central Management Servers - SQL Server 2008 - Ramireddy

Sat, 24 Mar 2012 08:18:00 GMT

By using Multi-server query, we can execute a query against multiple servers at a time. In Central Management server, register the available servers. ...

Database deployment - Ramireddy

Thu, 22 Mar 2012 22:27:00 GMT

VS 2010 allows you to optionally deploy a database, along with your web application files, when are using the “Web Deploy” option as your deployment m...

Getting Started with ASP.NET MVC - Part 4: Introduction to Different view engines Razor and ASP.NET - Jalpesh

Thu, 22 Mar 2012 02:18:00 GMT

In previous chapter, we have learned about controller, views, action results etc. In this chapter we will learn about the different type of view engin...

SQL Server – Creating and using Dump Devices for Backups - Vishal Gajjar

Mon, 19 Mar 2012 07:06:00 GMT

A dump device is simply a logical device which redirects to a specified physical device.

Visual Studio 2010 - Multi-Monitor support - Ramireddy

Sun, 18 Mar 2012 09:38:00 GMT

Visual Studio 2010's shell allows for any window to be floated and moved outside of the top-level window, including code and designer windows. This me...

SQL Azure federations gives scale-out performance - Ramireddy

Sun, 18 Mar 2012 00:51:00 GMT

SQL Azure federations gives scale-out performance

Validating an email address using regular expressions in C#.net - Kirti M.Darji

Fri, 16 Mar 2012 09:20:00 GMT

Validating an email address using regular expressions in C#.net

Reverse string without using loop and split method - Kirti M.Darji

Thu, 15 Mar 2012 08:25:00 GMT

Reverse string without using loop and split method

SQL Azure - Support for SQL Azure reporting - Ramireddy

Wed, 14 Mar 2012 07:07:00 GMT

In SQL Azure Service Pack 5, Microsoft announced an very important update, "Support for SQL Azure reporting", which is as of now in CTP. SQL Azure Rep...

HTML 5 - Keygen tag to improve security - Ramireddy

Tue, 06 Mar 2012 21:00:00 GMT

HTML 5 - Keygen tag to improve security

.NET Framework 4.0 - Permanently redirecting a method using RedirectPermanent - Ramireddy

Sun, 04 Mar 2012 08:28:00 GMT

.NET Framework 4.0 - Permanently redirecting a method using RedirectPermanent

ASP.NET 4.0 - ListView control enhancement - Ramireddy

Sun, 04 Mar 2012 06:21:00 GMT

ASP.NET 4.0 - ListView control enhancement

WCF # 13 – WCF Behaviors and it's types [How WCF runtime is initialized?] - Ganesh Divekar

Mon, 20 Feb 2012 16:52:32 GMT

In general Behavior or behaviour refers to the actions and mannerisms made by System in conjunction with its environment, which includes the other systems around . It is the response of the system to various stimuli or inputs.

Fun with Sqaure braces - Madhivanan

Mon, 20 Feb 2012 01:13:00 GMT

Square braces in SQL Server play a major role in T-SQL programming. When an object name contains a space, special character, etc, the only way to express them is to put them aroud squre braces.

Retrieve MarketPrice from FixServer using QuickFix - Neeraj Kaushik

Mon, 20 Feb 2012 00:23:00 GMT

This in continuation with previous post on QuickFix which explain how to connect to FIX Server and send order to Fix Server. I don't have any environment to test now. I just want to give idea about how can we get market price from FIX server if broker/exchange is sending market price in FIX messages.

#0136 - SQL Server – SSMS – Slow load times - Improving launch performance in 2 simple steps - Nakul Vachhrajani

Mon, 20 Feb 2012 00:00:00 GMT

As you know, I recently completed a 10-part tutorial series on the SQL Server Management Studio (SSMS). As I finished writing the tutorial, I remembered that one of the issues most SQL Server developers encounter are the slow

SQL Server - Changing Rows to Columns Using PIVOT - Paresh Prajapati

Sat, 18 Feb 2012 22:05:00 GMT

During working with one logic, i got chance to work with PIVOT operation. Sometime we need do require rowdata as column in our custom logic, then we can use some temp table and then populate agreegate data in temp table. But With PIVOT we can do it very easily.

SQL Server 2012 Certification Nearly Here - Jeff Wharton

Thu, 16 Feb 2012 23:35:29 GMT

While reviewing threads on the MSDN Training and Certification Forum, I read a reply from Nilkamal0007 in relation to a question on SQL Server 2012 certification. What caught my eye about this particular reply was that Nilkamal0007 provided links to exam content published in Microsoft’s exam catalogue; something I didn’t know had been published. So what does this mean? It means that the Beta cycle for these exams is close to going live.

OPENROWSET (T-SQL) – Sometimes You Have to Stop and Smell the Roses - Jeff Wharton

Thu, 16 Feb 2012 22:43:15 GMT

Ever been in the situation where you’re so fixated on debugging an error that you fail to see the solution which has been staring you in the face the whole time? Me too.

Object whitespace-naming madness - Szymon Wojcik

Thu, 16 Feb 2012 18:18:00 GMT

Have you ever tried creating objects and giving them strange names? I made some experiment at one of lab servers, main focus was space (you know, the long key at the bottom of the keyboard :D). So, without further ado - the first object to be tested is a database.

#0135 - SQL Server – SSMS – Tutorial – 10 - Troubleshooting (L200) - Nakul Vachhrajani

Thu, 16 Feb 2012 00:00:00 GMT

All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds.

Scope of permanent tables in tempdb database - Madhivanan

Tue, 14 Feb 2012 01:46:00 GMT

As you all know tempdb is responsible of storing all the temporary objects created for a server. One of my co-workers asked me "what is the scope of permanent tables created in the tempdb database?". The answer is it can be accessed via tempdb from various connections just like objects are accessed ...

#0134 - SQL Server – SSMS – Tutorial – 09 - Integrating with peripheral services & other SQL Server tools (L200) - Nakul Vachhrajani

Mon, 13 Feb 2012 00:00:00 GMT

As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager – the interface that is used to manage & maintain the SQL Server instance

SSIS - Delete files older than retention period from folder with parameter using Script Task in SQL Server - Paresh Prajapati

Fri, 10 Feb 2012 08:03:00 GMT

After using some of the ways to delete the files from the particular folder like Delete file using Script Task and File System Task in SSIS. We have seen such methods and used logic to get the files from the loop

SQL Server Integration Services 2012 (RC0) Project Conversion Bugs - Jeff Wharton

Thu, 09 Feb 2012 20:46:02 GMT

Stumbled across a couple of bugs the other day while upgrading a SSIS 2008 package to SSIS 2012 RC0. The bugs relate to using a FTP Task with a Server Port greater than 32767. The bugs identified have been reported via Microsoft Connect (item 721089) however I have been advised that fixes for these...

#0133 - SQL Server – SSMS – Tutorial – 08 - How SSMS helps in reviewing and configuring your SQL Server Instance (L200) - Nakul Vachhrajani

Thu, 09 Feb 2012 00:00:00 GMT

One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series

Question of the month February 2012 - Find out problamatic query - Madhivanan

Wed, 08 Feb 2012 01:03:00 GMT

Without running these queries can you find out the query that would throw an error?

C# - What are Named and Optional arguments? - Manas Ranjan Dash

Tue, 07 Feb 2012 20:32:00 GMT

While passing the arguments you can associate a specific parmeter by its name rather than passing the argument by its position, this is what the Named argument does.

Client side Model binding with ASP.NET MVC 3 and KnockoutJs - Neeraj Kaushik

Tue, 07 Feb 2012 00:40:59 GMT

Client side Model binding with ASP.NET MVC 3 and KnockoutJs Knockoutjs is type safe client side library which provides declarative bindings of DOM with model data

#0132 - SQL Server – SSMS – Tutorial – Part 07 - Database Administration and maintenance - Productivity enhancing features (L200 - Nakul Vachhrajani

Mon, 06 Feb 2012 00:00:00 GMT

The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks.

SQL Server 2012 Virtual Labs - Jeff Wharton

Sun, 05 Feb 2012 12:43:26 GMT

Want to play around with SQL Server 2012 but don’t have an environment to play around in? Check out the following SQL Server 2012 Virtual Labs:

Number- New HTML5 Input type - Jalpesh

Sun, 05 Feb 2012 01:28:05 GMT

I have been writing few series of new HTML5 input types and this is another post on same series. In this post I am going to explain Number input types.

URL–New HTML5 input element - Jalpesh

Sat, 04 Feb 2012 14:54:29 GMT

In earlier post we have seen how the email input tag work in the browser. HTML5 comes with lots of new goodies and today we are going to see one of another new html5 input types URL.

SSIS - Delete files older than retention period from specified folder using Script Task in SQL Server - Paresh Prajapati

Sat, 04 Feb 2012 07:18:00 GMT

Earlier we have seen for the Delete file using Script Task and files deletion using File System Task in SSIS.

Removing Otherwise method from CuttingEdge.Conditions - Steven

Sat, 04 Feb 2012 05:40:00 GMT

Removing Otherwise method from CuttingEdge.Conditions

10 Beginner Level Windows Azure Interview Question and Answers (Q&A) - Paras Doshi

Fri, 03 Feb 2012 00:29:00 GMT

10 Beginner Level Windows Azure Interview Question and Answers (Q&A)

#0131 - SQL Server – SSMS – Tutorial – Part 06 – Introduction to the Properties Window (L100) - Nakul Vachhrajani

Thu, 02 Feb 2012 00:00:00 GMT

The SQL Server Management Studio (SSMS) continues to fascinate me with it’s immense wealth of features geared towards developer & administrator usability.

SQL Server – COPY TABLE from another SQL Server - Jack Vamvas

Thu, 02 Feb 2012 00:00:00 GMT

SQL Server – COPY TABLE from another SQL Server

SQL Server 2012 Developer Training Kit BOM - Jeff Wharton

Wed, 01 Feb 2012 16:51:48 GMT

The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki.

Add SSRS 2008 named instance tutorial - Jason Yousef

Wed, 01 Feb 2012 14:38:06 GMT

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots.

Data Profiling Task to Validate data before load to EDW - Alpesh Patel

Wed, 01 Feb 2012 09:35:40 GMT

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.

Set the Slice on your SSAS Cube Partitions now! - Jason Thomas

Tue, 31 Jan 2012 22:35:52 GMT

I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue.

Identity column with decimal datatype - Madhivanan

Mon, 30 Jan 2012 01:14:00 GMT

One of the members in the forum asked about using decimal datatype in identity column. The question was "Is decimal point allowed in the identity column?" Ok.

#0130 - SQL Server – SSMS – Tutorial – Part 05 – The Wizards of SSMS - Table Designer, Query designer & Template Explorer (L - Nakul Vachhrajani

Mon, 30 Jan 2012 00:00:00 GMT

The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels.

Email-New Html5 input element - Jalpesh

Sun, 29 Jan 2012 14:50:02 GMT

In most of the websites we have contact forms and other forms where we have some standard inputs like Phone,Email and Website URL and those are widely used in any site and has specific features.

My first video for code refactoring in visual studio 2010 - Jalpesh

Sun, 29 Jan 2012 04:07:59 GMT

I have been planning this since long but now Its happened. I have created a video for visual studio 2010 code refactoring features. I have made this video public. Following is a link for that.

Error encountered in SQL Server - Alter failed for Login sa. Cannot set a credential for principal 'sa'. - Paresh Prajapati

Fri, 27 Jan 2012 20:19:00 GMT

Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following,

Stored Procedure to Get Expensive Queries - Manjunath C Bhat

Fri, 27 Jan 2012 11:02:05 GMT

As a DBA we often need to get information on various Queries, One of them is how expensive it is. A query can be judged as expensive on various criteria’s like Long Running, Memory Utilization, CPU utilization etc.

Stored Procedure to Purge MSDB Job History - Manjunath C Bhat

Fri, 27 Jan 2012 10:50:23 GMT

Purging your MSDB Job History is sometime very important which helps you read the Jos history in GUI very easily and keeps which only required number of days.

SQL Server – Error Logs recycle without SQL Server Restart - Jack Vamvas

Thu, 26 Jan 2012 01:00:00 GMT

If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages.

#0129 - SQL Server – SSMS – Tutorial – Part 04 – Introduction to Database Diagramming (L100) - Nakul Vachhrajani

Thu, 26 Jan 2012 00:00:00 GMT

For those who have worked in Enterprise environments, documentation is of utmost importance. Documentation can be in the form of a text-based document, or a graphical document (in the form of a diagram).

Generate test data using DBGen - Geniiius

Tue, 24 Jan 2012 01:00:00 GMT

Over the last couple of months I have on several occasions found myself in need of test data for demos, blogposts etc. You all know AdventureWorks, which will work for a lot of demoing stuff.

Free Introducing Microsoft SQL Server 2012 eBook (2nd Draft) - Jeff Wharton

Mon, 23 Jan 2012 23:15:35 GMT

The second draft of the free Introducing Microsoft SQL Server 2012 eBook will be released on 1st February 2012 and will contain the following chapters:

Using TraceEvent for MDX Debugging - Jason Thomas

Mon, 23 Jan 2012 11:02:18 GMT

Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today.

#0128 - SQL Server – SSMS – Tutorial – Part 03 – The T-SQL Debugger (L200) - Nakul Vachhrajani

Mon, 23 Jan 2012 00:00:00 GMT

More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability.

Dedicated Admin Connection (DAC) error in SQL Server 2012 RC0 - Sankar

Sun, 22 Jan 2012 01:00:00 GMT

Dedicated Admin Connection (DAC) in SQL Server doesn’t need any introduction now that it is in the product for almost 6-7 years i.e from the days of SQL Server 2005.

Working with Application Role - SQL Server - Paresh Prajapati

Fri, 20 Jan 2012 08:01:00 GMT

In last post we have seen custom database roles as how can we create it and assign required access to users. We also noticed that we can add multiple members with same role.

#0127 - SQL Server – SSMS – Tutorial – Part 02 – Introduction to the Object Explorer and Object Explorer Details window (L100) - Nakul Vachhrajani

Thu, 19 Jan 2012 00:00:00 GMT

As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio (SSMS) and the Query Editor window.

Troubleshooting SQL Azure Connection Issues - Jeff Wharton

Wed, 18 Jan 2012 16:28:43 GMT

Thanks to Paras Doshi for providing details on the following article relating to troubleshooting SQL Azure connection issues.

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook - Satya Jayanty (@sqlmaster)

Wed, 18 Jan 2012 13:32:00 GMT

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS).

Knowing minimum timestamp value for a database - Madhivanan

Wed, 18 Jan 2012 04:13:00 GMT

When a datatype timestamp or rowversion is used, it generates unique value whenever a row is added or updated in a table.

Troubleshooting SQL Server Connection Issues - Jeff Wharton

Tue, 17 Jan 2012 15:24:53 GMT

For those of us who spend time on the SQL Server Forums, you’ll probably agree that one of the most common calls for assistance relates to troubleshooting SQL Server connections.

How to keep a track of list of SQL Server versions and builds releases? #sqlversion - Satya Jayanty (@sqlmaster)

Tue, 17 Jan 2012 13:29:00 GMT

I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance.

TOP WITH TIES - Geniiius

Tue, 17 Jan 2012 01:00:00 GMT

I have been working with SQL Server for quite a few years now, and it still happens quite often that I discover new cool things to do in t-sql.

Reducing SSRS RDL size by uploading Shapefiles to ReportServer - Jason Thomas

Mon, 16 Jan 2012 01:42:00 GMT

I don’t know about you guys, but I am really petrified of public speaking. So I always try to read about it and it really gives me some comfort to know that I am not alone.

#0126 - SQL Server – SSMS – Tutorial – Part 01 – Introduction to the Management Studio and Query Editor (L100) - Nakul Vachhrajani

Mon, 16 Jan 2012 00:00:00 GMT

Per Books-On-Line, The Microsoft SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

DIRTY_PAGE_POLL wait type in SQL Server 2012 - Sankar

Sun, 15 Jan 2012 01:00:00 GMT

Looking at wait types in SQL Server is a great way to get some insight into how SQL Server is operating under the current load. Although wait types in SQL Server are around from the days of SQL Server 2000 (may be earlier), it has improved significantly from SQL Server 2005.

SSIS #106 – You can create package configuration files to make SSIS package dynamic and portable - Sherry Li

Sat, 14 Jan 2012 07:07:00 GMT

I had many posts that share my experiences with using package configuration files to make my SSIS packages portable from my local development BIDS environment, to the test environment, and the production environment.

Microsoft Virtual Academy - Jeff Wharton

Fri, 13 Jan 2012 13:09:46 GMT

The Microsoft Virtual Academy (MVA) is a free cloud-based learning environment focusing on Microsoft Technologies (Although the site states that it focuses on cloud-based technologies, I have found content in some countries not specific to the cloud).

SQL Server - Custom Database Role - Paresh Prajapati

Fri, 13 Jan 2012 07:53:00 GMT

Recently while working with database security, I learned database roles as how the each role used. Apart from the server level roles if we need to require to assign access/rights to particular databases level then we need to go through database level roles.

SQL Server 2012 FileTable – Part 2 - Geniiius

Thu, 12 Jan 2012 01:00:00 GMT

In post shows how easy it is to combine FileTables and FullText Search.

SQL Server – Know your query SET options – Properties window and DBCC USEROPTIONS - Nakul Vachhrajani

Thu, 12 Jan 2012 00:00:00 GMT

The properties and behaviour of each session to a SQL Server instance can be handled individually via use of various SET options.

Question of the month January 2012 - Datatype of NULL - Madhivanan

Wed, 11 Jan 2012 13:25:00 GMT

Without running the following code, can you guess the datatype of the column t?

Retired SQL Server Certifications - Jeff Wharton

Wed, 11 Jan 2012 09:52:33 GMT

The following SQL Server exams are due to retire on 31 July 2012:

SQL Server Page Restore - Ana

Tue, 10 Jan 2012 00:00:00 GMT

We all know how backup is important. I usually say that restore is more important than backup. We can create backup but if we don’t know how to restore it

DB2 security audit - Jack Vamvas

Tue, 10 Jan 2012 00:00:00 GMT

The SYSIBM.SYSDBAUTH maintains user privileges on databases, The SYSIBM.SYSPLANAUTH maintains user privileges on plans, The SYSIBM.SYSUSERAUTH maintain user privileges on the system.

T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query - Robert Pearl

Tue, 10 Jan 2012 00:00:00 GMT

Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New Year, 2012, it's the perfect time to start over again, and make up for the things that you missed, should the opportunity present itself. That's why I am blogging right now

SQL Server Index Fragmentation Script - Jeff Wharton

Mon, 09 Jan 2012 23:01:33 GMT

Just sharing a cool script I stumbled across while searching for SQL Server index fragmentation scripts (Omer van Kloeten's Blog). I’ve cleaned it up a bit and turned it into a Stored Procedure so that I can execute it as a SQL Server Agent Job

@@TRANCOUNT is always get incremented in a trigger - Madhivanan

Mon, 09 Jan 2012 01:24:00 GMT

The system variable @@TRANCOUNT is used to get the number of transactions that are active. Consider the following code