SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : tsql

TSQL to find the name of unique index that refers full text index

Mon, 03 Aug 2009 06:45:00 GMT

Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the name of unique index that refers full text index SELECT OBJECT_NAME ( fti . object_id ) AS 'Table Name' , i . name AS 'Index Name'...(read more)

TSQL tip on how much is the usage of database indexes?

Sun, 26 Jul 2009 22:43:00 GMT

Recently there hasn't been much of SQL Server tasks for me, as most of the time I was involved on designing the solutions for larger installations - a 8 node cluster or VLDB configuration etc. Ok I admit that still it can be classified as SQL Server...(read more)

Pattern and Practices - deprecate and discontinued Transact SQL features

Thu, 23 Apr 2009 07:10:00 GMT

Deprecate and Discontinued features, are not a words for Developers and DBAs which is a first point of option that they must be concentrated. What they mean is the defined features include a complete/partial change in supported compatibility levels, for...(read more)

A big question in SQL Server - create a table with more than 1024 columns?

Mon, 06 Apr 2009 07:46:00 GMT

IT was an interesting question to ask/know about create a table with more than 1024 columns? If you try to do so then obvious error: CREATE TABLE failed because column '<ColName>' in table 'MaxSparseColumnTest' exceeds the maximum...(read more)

Database diagram issues after SQL Server upgrade

Wed, 18 Feb 2009 07:50:00 GMT

Have you planned your databases upgrade from SQL Server 2000 version to 2005 or 2008? Have you tested the above upgrade plan? How many times you have been involved in the number of databases upgrade within your platform? Many questions to answer when...(read more)

SQL Server TSQL security concerns - highlights for a newbie reference

SqlServer-QA.net — Mon, 05 Jan 2009 07:01:00 GMT

Here it is first post in the year 2009, still I would like to visit the good old advice of securing your SQL Server environment. For any user in IT, Security must be a top priority in order to ensure their PC or environment is secured. You might have...(read more)

sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

SqlServer-QA.net — Wed, 17 Dec 2008 07:10:00 GMT

Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...(read more)

Temporary tables existence during Dynamic SQL usage in SQL Server

SqlServer-QA.net — Thu, 13 Nov 2008 07:33:00 GMT

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 ON DROP TABLE Employee CREATE...(read more)

SQL Server 2008 - TSQL fundamentals, get a great resource on this topic!

SqlServer-QA.net — Wed, 15 Oct 2008 08:32:00 GMT

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...(read more)

How to write or deploy Secure Transact-SQL - gotchas & tips?

SqlServer-QA.net — Thu, 18 Sep 2008 07:16:00 GMT

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...(read more)

SQLTeach/DevTeach Montreal registration open -- early bird discounts

SSQA.net — Thu, 04 Sep 2008 08:30:00 GMT

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...(read more)

Lighter side of a TSQL query :: Wedding Style

SSQA.net — Sat, 09 Aug 2008 16:45:00 GMT

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...(read more)

TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

SSQA.net — Mon, 14 Jul 2008 10:26:00 GMT

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...(read more)

Quick and simple way to know the stored procedures parameters using TSQL

SSQA.net — Tue, 08 Jul 2008 11:13:00 GMT

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...(read more)

FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"

SSQA.net — Thu, 03 Jul 2008 21:46:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New FIX: Error message after...(read more)

SQL Server 2005 DMV - quick information to find resource allocation & DDL bottleneck

SSQA.net — Mon, 09 Jun 2008 08:29:00 GMT

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...(read more)

SQL Server: Creating BlackBox kind of trace with TSQL

SSQA.net — Wed, 28 May 2008 11:59:00 GMT

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...(read more)

How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

SSQA.net — Tue, 20 May 2008 08:12:00 GMT

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...(read more)

SQL Server 2005 detect DAC session with TSQL

SSQA.net — Fri, 09 May 2008 18:11:00 GMT

SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important...(read more)

SQL Server: Quick way to find Active & idle connections on a SQL instance

SSQA.net — Fri, 02 May 2008 09:32:00 GMT

Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system...(read more)