SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
Browse by Tags
All Tags
»
tsql
(
RSS
)
2005
access
backups
best practice
best practices
blocking
blog
blogs
cache
check
clr
code
collation
columns
compiled
computed
configuration
connections
constraint
cpu
create
creation
crosstab
css
cte
cursor
dac
data file
data sources
database
database mirroring
databases
datatype
dba
declare
dmv
dynamic
dynamic sql
edition
engine
enhancement
enterprise
enterprise manager
errorr
event
execution
forced
function
high availability
iif
indexes
information schema
location
locks
log file
login
management
mdx
memory
merge
microsoft
monitoring
object_name
performance
permission
principal
publisher
query
replication
report builder
reporting services
schema
script
security
select
server
snapshot
sql server
ssms
statistics
stored procedure
system
table
tablename
tables
technet
toolkit
top
trace
trace flag
transaction
transactional
trigger
triggers
try
try-catch
tuning
version
view
xml
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2000
2005
2008
access
analysis
Analysis Services
application
backup
backups
best practice
best practices
bi
blocking
blog
blogs
BOL
business continuity
cache
clustering
community
conference
configuration
cpu
ctp
data
database
database mirroring
databases
dba
dbcc
disaster recovery
disk
disk space
dmv
download
dts
enterprise
environment
error
error log
event
features
hardware
high availability
i/o
indexes
installation
integration
katmai
kba
login
management
management studio
memory
merge
microsoft
monitoring
msdn
mvp
package
performance
publisher
query
replication
report builder
reporting
reporting services
restore
sa
script
security
server
service pack
service pack2
services
sharepoint
snapshot
sp2
sql express
sql server
ssas
ssis
ssms
stored procedure
support
table
tables
technet
testing
tools
transaction log
tsql
tuning
update
upgrade
users
version
webcast
windows
x64
Navigation
Home
Blogs
Photos
Downloads
Archives
May 2008 (19)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
News
Syndication
RSS
Atom
Comments RSS
Receive Email Updates
Subscribe