Browse by Tags

SQL Server Blog

Home
Contact

Syndication

News

Why don't you take a few minutes to join Strangenut, I'm trying to build an interactive community and would love to have your feedback on what I write and suggestions and questions I can answer! It's free, I won't spam you, and won't sell your address to anyone!

Programming

Archives

What does schemabinding mean in SQL 2005 and 2008?

In order for us to be able to create an indexed view, we need to create that view with SCHEMABINDING specified. What exactly does SCHEMABINDING mean? Here is the definition from MSDN: SCHEMABINDING Binds the view to the schema of the underlying table...

Published Tue, Dec 12 2008 10:06 AM by dacrowlah

Filed under: T-SQL, database, SQL Server
Creating an Indexed View in SQL Server 2005 and 2008

As you probably are already aware, a view in SQL Server is generated off of a pre-defined select statement, and is a flexible solution to use when ever you are doing database driven application development; particularly when you are using an ORM tool...

Published Wed, Nov 11 2008 4:33 PM by dacrowlah

Filed under: T-SQL, performance tuning, database, SQL Server
Writing Your First CLR Stored Procedure

In SQL Server 2005 and 2008 the Common Language Runtmie (CLR) is tightly integrated with the database engine, allowing you to write stored procedures in any .NET language such as C# and VB.NET. CLR stored procedures have some distinct advantages over...

Published Fri, Oct 10 2008 6:25 PM by dacrowlah

Filed under: T-SQL, database, SQL Server, c#, stored procedure, CLR Stored Procedures
How to enable CLR Stored procedures on SQL Server 2005 and 2008

In order to make CLR stored procedures run, you must first enable the CLR in SQL Server, other wise you will just get this error: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. Enabling the...

Published Sun, Oct 10 2008 8:53 PM by dacrowlah

Filed under: T-SQL, database, SQL Server, beginner, stored procedure
Making the case for stored procedures

On a few of the mailing lists I am on for developers (primarily ones related to web development), there is a recurring topic that always gets people into rather heated debates: to use stored procedures or prepared statements? Now, either one you choose...

Published Sun, Oct 10 2008 2:23 AM by dacrowlah

Filed under: query execution plans, T-SQL, performance tuning, database, SQL Server, beginner, stored procedure
Getting a range of values from an arbitrary starting point in T-SQL

Recently a friend of mine called with a question about how to do something in T-SQL that he wanted to do for the leaderboard for a game he wrote. The issue was that tens of thousands of people are playing his game (on the iPhone) and the screen real estate...

Published Thu, Aug 08 2008 12:40 PM by dacrowlah

Filed under: T-SQL, database, SQL Server
The Basics of Database Normalization - Explained

Data Normalization , refers to creating a structure to store your data in that results in reduction/elimination of redundant data. In a pure normalized form, a piece of data exists only in one place. Anywhere that the data is displayed is only making...

Published Wed, Jul 07 2008 5:05 PM by dacrowlah

Filed under: database, SQL Server, beginner
Engineering Managers: Top Ten Things Your DBA Should Be Doing

Recently I got a request for a top 10 list of things that a DBA should be doing on a daily basis from an engineering managers perspective. Well, here is what I came up with, and please note, that this list is dependant on the poor guy being a full-time...

Published Tue, Jun 06 2008 12:28 PM by dacrowlah

Filed under: T-SQL, database, SQL Server
How to alter a table that is being published for replication

Many times I have found myself needing to make changes to an existing table that is being published for replication. Here is a script that I have been using for a few years now that has served me well and never caused issues. Hope you find it useful....

Published Tue, May 05 2008 8:13 PM by dacrowlah

Filed under: T-SQL, database, SQL Server
Paging and Available Memory for Operating system, what you need to know?

Found this great article on interpreting PERFMON statistics. Being able to make sense of this is critical to doing advanced performance tuning on your SQL Server. This type of stuff goes more towards system administration more than programming. I myself...

Published Sat, Apr 04 2008 9:43 PM by dacrowlah

Filed under: performance tuning, database, SQL Server
ClearTrace - great free tool for troubleshooting database performance issues

ClearTrace is a free tool available for download that will analyze SQL Server trace files and trace tables to give you a normalized view of query performance. It offers various sorting capabilities From the site: ClearTrace imports SQL Server 2000 and...

Published Thu, Apr 04 2008 8:06 PM by dacrowlah

Filed under: performance tuning, database, SQL Server
Query to get the parameter list along with datatypes and maxlength for SQL 2005

Today we had a need for a query that would return information on a stored procedure and give us a list of parameters, datatypes, and max values. This functionality is built into the data adapter but we wanted a little bit more flexibility on how we used...

Published Thu, Apr 04 2008 3:24 PM by dacrowlah

Filed under: T-SQL, database, SQL Server, stored procedure
Dissapointed with the quality of technical journalism

Ok, so this weekend I was reading up on some ways to write high performance T-SQL, as I am always on the hunt for new ideas. I came across this link where the author, Tim Chapman, has written a series of articles on SQL Server programming, administration...

Published Sun, Feb 02 2008 10:49 PM by dacrowlah

Filed under: query execution plans, T-SQL, performance tuning, database, SQL Server

Browse by Tags

Syndication

Recent Posts

Tags

News

Programming

Archives