Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » Samples   (RSS)

Show all index and heap access operators in the plan cache

with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan') select x.value(N'@NodeId',N'int') as NodeId , x.value(N'@PhysicalOp', N'sysname') as PhysicalOp , x.value(N'@LogicalOp', N'sysname') as LogicalOp , ox.value(N'@Database',N'sysname') Read More...
Posted 28 ianuarie 2012 01:42 from rusanu.com | (Comments Off)

SQL Server table columns under the hood

You probably can easily answer a question like ‘What columns does this table have?’. Whether you use the SSMS object explorer, or sp_help, or you query sys.column, the answer is fairly easy to find. But what is I ask ‘What are the physical Read More...
Posted 21 octombrie 2011 01:36 from rusanu.com | (Comments Off)

T-SQL functions do no imply a certain order of execution

Looking at this question on StackOverflow: Conversion failed when converting from a character string to uniqueidentifier error in SQL Server one can see a reproducible example where a string split UDF works fine in the SELECT statement, but it gives a Read More...
Posted 10 august 2011 11:48 from rusanu.com | (Comments Off)
Filed under: ,

FILESTREAM MVC: Download and Upload images from SQL Server

In a previous article I have shown how it is possible to use efficient streaming semantics when Download and Upload images from SQL Server via ASP.Net MVC. In this article I will go over an alternative approach that relies on the FILESTREAM column types Read More...
Posted 7 februarie 2011 06:05 from rusanu.com | (Comments Off)

How to pass a NULL value in a message to a queue in SQL Server

The SEND Transact-SQL verb does not allow to send a NULL message body, attempting to do so will result in error: Msg 8433, Level 16, State 1, Line 11 The message body may not be NULL. A zero-length UNICODE or binary string is allowed. But there are ways Read More...
Posted 15 ianuarie 2011 20:08 from rusanu.com | (Comments Off)

Download and Upload images from SQL Server via ASP.Net MVC

A frequent question that pops up on discussion forums is how to serve an image that is stored in a SQL Server table from an ASP.Net application. Unfortunately the answer is almost always wrong, as the prevalent solution involves copying the entire image Read More...
Posted 29 decembrie 2010 08:19 from rusanu.com | (Comments Off)

Using tables as Queues

A very common question asked on all programming forums is how to implement queues based on database tables. This is not a trivial question actually. Implementing a queue backed by a table is notoriously difficult, error prone and susceptible to deadlocks. Read More...
Posted 26 martie 2010 21:02 from rusanu.com | (Comments Off)

Performance comparison of varchar(max) vs. varchar(N)

The question of comparing the MAX types (VARCHAR, NVARCHAR, VARBINARY) with their non-max counterparts is often asked, but the answer usually gravitate around the storage differences. But I’d like to address the point that these types have inherent, Read More...
Posted 23 martie 2010 06:03 from rusanu.com | (Comments Off)

select count(*);

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/10/26/select-count/  Quick trivia: what is the result of running SELECT COUNT(*);? That’s right, no FROM clause, just COUNT(*). The answer may be a little Read More...
Posted 26 octombrie 2009 21:49 from rusanu.com | (Comments Off)

Passing Parameters to a Background Procedure

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/18/passing-parameters-to-a-background-procedure/  I have posted previously an example how to invoke a procedure asynchronously using service Broker activation. Read More...
Posted 18 august 2009 21:21 from rusanu.com | (Comments Off)

Asynchronous procedure execution

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/05/asynchronous-procedure-execution/  Recently an user on StackOverflow raised the question Execute a stored procedure from a windows form asynchronously and Read More...
Posted 5 august 2009 11:26 from rusanu.com | (Comments Off)

Detect network connectivity changes in .Net applications

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/21/detect-network-connectivity-changes-in-net-applications/  A common problem for applications that use the network stack is to detect when they are connected Read More...
Posted 22 iulie 2009 05:08 from rusanu.com | (Comments Off)

Exception handling and nested transactions

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/  I wanted to use a template for writing procedures that behave as intuitively as possible in regard to nested Read More...
Posted 11 iunie 2009 13:40 from rusanu.com | (Comments Off)

Using XSLT to generate Performance Counters code

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/04/11/using-xslt-to-generate-performance-counters-code/  Whenever I’m faced with a project in which I have to create a lot of tedious and repeating code Read More...
Posted 11 aprilie 2009 02:13 from rusanu.com | (Comments Off)
Filed under:

How does Certificate based Authentication work

Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/10/23/how-does-certificate-based-authentication-work/  Service Broker and Database Mirroring may use certificates for authenticating endpoints as an alternative Read More...
Posted 23 octombrie 2008 21:52 from rusanu.com | (Comments Off)
Filed under:
More Posts Next page »