SqlServer-QA.net

Here is an interesting question posted in the forums here asking about: Lots of time I face the problem with dynamic sql that I cant get the temporary table with data created through dynamic sql. for instance: SET NOCOUNT ONDROP TABLE EmployeeCREATE TABLE Employee(EmpId INT, EmpName VARCHAR(50), Sal    DECIMAL(13,2))INSERT INTO ...

I thought I can blog this post in SQL 2008 blog section, but the subject is more appealing towards Transact SQL so here it is. Do you want to know about Transact-SQL (TSQL) fundamentals? Are you interested to get insight of SQL Server 2008 TSQL topic by Itzik Ben-Gan? (I believe no one says, no) Then here is the wonderful opportunity for you ...

I have been thiking to write this topic in this blog since last 3 months, before that I have done fair amount of work to get you sensible & helpful resource in securing your SQL Server environment.  This was the question asked by one of the user when there was a discussion about securing the SQL Server code. The obvious answer is yes ...

En français Get a 300$ early bird discount by registering before September 13th. We are offering an early bird of 300$ CAD for attendees that are registering before September 13th, 2008. Registered attendees have access to the DevTeach Archive sessions material for download. Early registration (3 Days) Cost CAN Cost ...

Writing a better TSQL query will get you better performance, in terms of system & life-style too. Here is the email I received from my BIL, too get a     lighter side of blending a TSQL query as Stored Procedure (from а BrideGroom) .... guess what would be end result of that Stored Procedure!!   ...

DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10        total_logical_reads,       ...

As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA views you can get further information on what kind of parameters are used within a ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique ...

Initially I preferred to put this blog post within Performance tuning blog section here, but as it relates to the TSQL script thought this is best place to go. Anyways, if you have a performance problem the foremost option is to find whether the server resources are utilized properly or not, this is where SQL Server migth encounter the allocation ...

Here is the kind of scripts defined within TEchnet articles about running black-box kind of traces against your SQL Server instance, then also you can  take advantage of the blackbox trace if you are facing intermittent problems, you want to make sure that it is always running when your server is running—including after either a planned ...