MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

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

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'...

Published Mon, Aug 3 2009 1:45 by SqlServer-QA.net

Filed under: sql server, index, table, full-text, tsql, object_name
TSQL tip on how much is the usage of database indexes?

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...

Published Sun, Jul 26 2009 17:43 by SqlServer-QA.net

Filed under: sql server, indexes, dmv, usage, tsql, object_name, behaviour changes, lookups, index usage
Pattern and Practices - deprecate and discontinued Transact SQL features

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...

Published Thu, Apr 23 2009 2:10 by SqlServer-QA.net

Filed under: sql server, version, features, best practices, deprecated, tsql, dependancies, discontinued
A big question in SQL Server - create a table with more than 1024 columns?

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...

Published Mon, Apr 6 2009 2:46 by SqlServer-QA.net

Filed under: sql server, blog, best practices, tsql, 1024, sparse columns, limit, db engine, create table
Database diagram issues after SQL Server upgrade

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...

Published Wed, Feb 18 2009 1:50 by SqlServer-QA.net

Filed under: sql server, databases, dba, upgrade, best practices, tsql, administrator, diagram, FAQ
SQL Server TSQL security concerns - highlights for a newbie reference

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...

Published Mon, Jan 5 2009 1:01 by SqlServer-QA.net

Filed under: sql server, security, edition, development, stored procedure, tsql, production, select
sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

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...

Published Wed, Dec 17 2008 1:10 by SqlServer-QA.net

Filed under: sql server, security, replication, permissions, best practices, tsql, sp_repl, functional
Temporary tables existence during Dynamic SQL usage in SQL Server

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...

Published Thu, Nov 13 2008 1:33 by SqlServer-QA.net

Filed under: sql server, insert, tempdb, tsql, dsql, dynamicsql, temporary table
SQL Server 2008 - TSQL fundamentals, get a great resource on this topic!

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...

Published Wed, Oct 15 2008 3:32 by SqlServer-QA.net

Filed under: sql server, tsql, resource, new features, book, comments, fundamentals
How to write or deploy Secure Transact-SQL - gotchas & tips?

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...

Published Thu, Sep 18 2008 2:16 by SqlServer-QA.net

Filed under: sql server, documentation, best practices, tsql, injection, reference, guidelines, dynamicsql
SQLTeach/DevTeach Montreal registration open -- early bird discounts

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...

Published Thu, Sep 4 2008 3:30 by SSQA.net

Filed under: sql server, community, features, tsql, conference, sqlteach, devconnections
Lighter side of a TSQL query :: Wedding Style

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...

Published Sat, Aug 9 2008 11:45 by SSQA.net

Filed under: sql server, procedure, drop, tsql, lighter side
TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

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...

Published Mon, Jul 14 2008 5:26 by SSQA.net

Filed under: sql server, dmv, tsql, sysindexes, query plan, querystats
Quick and simple way to know the stored procedures parameters using TSQL

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...

Published Tue, Jul 8 2008 6:13 by SSQA.net

Filed under: sql server, stored procedure, tsql, information schema, parameter, views
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"

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...

Published Thu, Jul 3 2008 16:46 by SSQA.net

Filed under: sql server, kba, tsql, clustered index, dbcc dbreindex, 2511, unique
SQL Server 2005 DMV - quick information to find resource allocation & DDL bottleneck

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...

Published Mon, Jun 9 2008 3:29 by SSQA.net

Filed under: sql server, performance, dmv, tsql, contention, ddl, bottleneck
SQL Server: Creating BlackBox kind of trace with TSQL

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...

Published Wed, May 28 2008 6:59 by SSQA.net

Filed under: sql server, profiler, trace, tsql, size, blackbox
How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

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...

Published Tue, May 20 2008 3:12 by SSQA.net

Filed under: sql server, backup, table, drop, stored procedure, tsql, best practice, views
SQL Server 2005 detect DAC session with TSQL

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...

Published Fri, May 9 2008 13:11 by SSQA.net

Filed under: sql server, security, dmv, tsql, dac, session
SQL Server: Quick way to find Active & idle connections on a SQL instance

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...

Published Fri, May 2 2008 4:32 by SSQA.net

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active

1 2 3 4 5 Next > ... Last »

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

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

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

Pattern and Practices - deprecate and discontinued Transact SQL features

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

Database diagram issues after SQL Server upgrade

SQL Server TSQL security concerns - highlights for a newbie reference

sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

Temporary tables existence during Dynamic SQL usage in SQL Server

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

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

SQLTeach/DevTeach Montreal registration open -- early bird discounts

Lighter side of a TSQL query :: Wedding Style

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

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

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"

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

SQL Server: Creating BlackBox kind of trace with TSQL

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

SQL Server 2005 detect DAC session with TSQL

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