Browse by Tags

Get SQL Server Clustering information with DMVs and SELECT statements

Published 11 March 8 12:16 PM | SSQA.net

Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will...

Filed under: sql server, dmv, best practices, cluster, clustering, select, virtual server, nodes, shared drives, serverproperty

Understanding Single quotes within a SELECT statement

Published 19 February 8 1:19 PM | SSQA.net

This is for newbies who struggle to understand how single quotes work in SQL Server I have seen newbies worrying why the following doesnt work SELECT columns from mytable where col = 'Lifco' s ' When you specify a value which has single quote...

Filed under: sql server, select, newbie, T-SQL, statement, single quotes

How to use TSQL to find the size of total and free physical memory within the SQL Server?

Published 24 January 8 4:28 PM | SSQA.net

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With...

Filed under: sql server, performance, memory, microsoft, dump, physical, tsql, select, css, size

TSQL to return internal table columns and column data types?

Published 1 November 7 9:26 AM | SSQA.net

SELECT SCHEMA_NAME(itab.schema_id) AS schema_name ,itab.name AS internal_table_name ,typ.name AS column_data_type ,col.* FROM sys.internal_tables AS itab JOIN sys.columns AS col ON itab.object_id = col.object_id JOIN sys.types AS typ ON typ.user_type_id...

Filed under: sql server, tsql, select, tablename, internal tables

Audit the activity such as SELECT statements - CDC

Published 30 August 7 6:2 AM | SSQA.net

Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in...

Filed under: sql server, microsoft, security, audit, 2008, cdc, monitoring, select