Have you ever wondered as to which database is first made online when a SQL Server instance starts? When are user databases made available in the startup sequence? When is the tempdb available? Today, I try to find answers to these questions....

Queries appear to behave in a similar way under NOEXEC and FMTONLY SET options. Hence, how is FMTONLY different from NOEXEC? Does it really execute a query when there are no visible side-effects of the query execution? Today's post attempts to answer th...

Queries appear to behave in a similar way under NOEXEC and FMTONLY SET options. Hence, how is FMTONLY different from NOEXEC? Does it really execute a query when there are no visible side-effects of the query execution? Today's post attempts to answer th...

Found another good reason to avoid using IN clause in your TSQL Queries. See the example below: <pre style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(http...

Found another good reason to avoid using IN clause in your TSQL Queries. See the example below: <pre style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(http...

Microsoft introduced Snippets and Surround With in SQL Server 2012. In this post we can see how to use those both options. And how to create User Defined Snippets....

Microsoft introduced Snippets and Surround With in SQL Server 2012. In this post we can see how to use those both options. And how to create User Defined Snippets....

Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the ...

Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the ...

@dmitri, I could not understand what you want to tell. The example you gave can be executed without making it dynamic. CREATE VIEW dbo.test AS SELECT * FROM sys.objects This statement can be executed directly to create a view in any databas...