Browse by Tags

SQL Server 2005 detect DAC session with TSQL
09 May 08 01:11 PM | SSQA.net

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

Filed under: sql server, security, dmv, tsql, dac, session

SQL Server: Quick way to find Active & idle connections on a SQL instance
02 May 08 04:32 AM | SSQA.net

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

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

SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object
22 April 08 03:01 AM | SSQA.net

Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was...

Filed under: sql server, access, best practices, object, 2005, tsql, schemas, alter authorisation

SQL Server Replication - resolving too many snapshots issues?
15 April 08 06:15 AM | SSQA.net

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

SQL Server 2008 TSQL enhancements - what I like?
04 April 08 09:58 AM | SSQA.net

Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...

Filed under: sql server, performance, blogs, technet, merge, tsql, plan guide, new features, tvp, table-value

SQL Server 2008 - TSQL behavioural changes and enhancements
31 March 08 02:00 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.
17 March 08 04:39 AM | SSQA.net

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...

Filed under: sql server, blocking, dmv, version, 2000, pack, 2005, tsql, errorr, tablels, incorrect syntax

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 01:24 PM | SSQA.net

Cross post from my BlogCasts site....( read more ) Read More...

Filed under: sql server, blog, table, tsql, collation, changes

Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005
11 March 08 07:05 PM | SSQA.net

You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users...

Filed under: sql server, BOL, permission, tsql, privilege, user schema, definition

TSQL to get clustered index information in SQL Server 2005
10 March 08 03:00 AM | SSQA.net

Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index...

Filed under: sql server, dmv, tsql, schema, information schema, declare, clustered index

SQL Server Audit Trace - things you need to take care!
06 March 08 03:17 AM | SSQA.net

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need...

Filed under: SOX, sql server, microsoft, solution, dmv, trace, audit, tsql, trace flag, c2

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!
15 February 08 04:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

More Posts Next page »