List of blogs

List of blogs

Karthick P.K - karthick krishnamurthy

22 Sep 2011 9:08 PM

Comments 0

My “c:\” Drive gets full when I open the profiler trace
System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
Beyond XP_READERRORLOG (parameters of XP_readerrorlog)
A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
Script to free cache
How to find SQL Server and system CPU usage history :
The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive
Script to get current blocking tree with wait types
SQLServer2008: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
SQLServer 2008 Fails to come online on cluster after upgrade
I get error while I update a row in immediate updating subscription what is the cause?
Tasks and connection icons missing after importing DTS in SQL Server management studio
Runtime error: ActiveX component can’t create object: ‘SQLDMO.SQLServer’
I get Exception when i open SQL Server management studio
Using DMVs to find out the index usage history- SQL Server Index Usage
I cant not backup my database from SSMS….
We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.
How to Analyze “Deadlocked Schedulers” Dumps?
Configuring SSL for SQL Server using Microsoft Certificate Authority Server
“Value cannot be null” when i connect SQL Server from SSMS
How to find all the profiler traces running on my SQL Server
DBCC CheckDB fails with error “The database could not be checked as a database snapshot could not be created and the database or table could not be locked
How to get SQL Text and Query Plan for statements which are executing now
Script to clear stats
How to monitor the Session and query which Consumes Tempdb
Trivial Plan
How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.
Different Status bits of sysdatabases in SQLServer
Installation of SQLServer2008 fails (The registry key SYSTEM\CurrentControlSet\Services\RsFx0102\InstancesShares is missing)
Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)
Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.
Using DMVs to find out the index usage history- SQLServer Index Usage
Script to get all the Query and cached plans
How to find who altered my SQL Server Login
How to Browse (or) view objects and there code in mssqlsystemresource Database
Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)
Behavior of SQL Server default instance on a NON-Default port
Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher
How to enable Constraint delegation for SQLServer2005

Comments

Leave a Comment

Name
Comment
Please add 5 and 7 and type the answer here:
Post