SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
May 2007 - Posts
Troubleshoot a process (SPID) using tools & TSQL queries
Published 31 May 7 10:50 AM |
SSQA.net
First thing a DBA would follow to troubleshoot a query is to look at the process (SPID) ID for that query and with the help of Enterprise Manager tool looking at the Current Activity option under management pane will give you list of processes that are...
Get SYSMON counters using a TSQL query aka DMVs.
Published 31 May 7 10:26 AM |
SSQA.net
SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using...
How to find list of DMVs & DMFs?
Published 31 May 7 9:22 AM |
SSQA.net
As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism...
Changes to SQL Server TechCenter
Published 30 May 7 8:45 AM |
SSQA.net
You might have observed or not there is a change in the MSDN documentation User Interface (UI) and the way it is connected with regard to the feedback from the user. Well SQL Server TechCenter has been given a new look with an UI face-off in addition...
What we have and what we need in BI?
Published 30 May 7 5:15 AM |
SSQA.net
There is no doubt that from SQL Server 2005 version onwards Business Intelligence (BI) solutions has been better as compared to the previous versions. Still it is interested to know what is the Microsoft's strategy on the expansion of BI. Having the...
Trigger a trigger event when a new trigger is created
Published 29 May 7 4:50 AM |
SSQA.net
Trigger a trigger event when a new trigger is created, for a moment I was muffled with number of times you need to mention to call the subject. So looking at the need you will have to ask whether it is possible or not. Coming to the subject, yes it is...
SQL Server 2005 Analysis Services community samples
Published 29 May 7 4:44 AM |
SSQA.net
As the evolution of Analysis Services has taken to new heights in SQL Server 2005 equally the users are looking to deploy on the large scale and having a need to go though the samples that are helpful. So how about referring to a project that contains...
Things to take care before installing SQL Server 2005 on Vista operating system or Windows Server 2008?
Published 29 May 7 3:29 AM |
SSQA.net
I have seen mounting questions asking on support for SQL Server 2005 on Vista & Windows 2008, what a surprise! As Windows Server 2008 (aka Longhorn) is still in CTP (BETA 3) stages it is hard to comment or confirm any sort of support arrangements...
Vote now: Index defragmentation best practices for SQL Server 2005
Published 25 May 7 6:35 PM |
SSQA.net
From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...
Mount Points and Clustering blurb for SQL Server & windows operating system
Published 25 May 7 6:18 PM |
SSQA.net
Mount Point is the new concept introduced in the Windows 2003 Server (R2) that works as a mounted drive is a volume or a drive that is mapped to a folder on a volume that uses the NTFS file system. Mounted drives function as any other volume or drive...
Disaster recovery options for SQL Server
Published 25 May 7 6:13 PM |
SSQA.net
Have you ever wondered what could be the Disaster Recovery (DR) options available for SQL Server. In the documentation terms: Disaster recovery is a process that you can use to help recover information systems and data, if a disaster occurs. Some examples...
A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 - Reporting Services 2005
Published 25 May 7 6:10 PM |
SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete KBA - A list of the bugs that are fixed in SQL Server 2005 Service Pack 2...( read more ) Read More...
A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 for Standard Edition
Published 25 May 7 6:8 PM |
SSQA.net
Modified KBA: Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications KBA - A list of the bugs that are fixed in SQL Server 2005 Service Pack 2...( read more ) Read More...
KBA: SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)
Published 25 May 7 6:7 PM |
SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications KBA - SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)...( read more ) Read More...
Delete DEMO alerts from SQLAgent
Published 25 May 7 9:24 AM |
SSQA.net
Since the days of SQL 70 automated administrative tasks are getting better with the usage of SQLAgent, you need to know how to configure alerts and set up operators, the people SQL Server contacts when alert conditions arise. SQLAgent Jobs can trigger...
Swiss-knife features in SQL Server to help you
Published 25 May 7 8:11 AM |
SSQA.net
Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface....
Annoying x80040E21 & x80040E24 errors
Published 25 May 7 4:41 AM |
SSQA.net
If you are performing a simple process to import a data using a DTS package in SQL 2000 or an SSIS package in SQL 2005, you might be very familiar with errors such as "x80040E21 & x80040E24". To put more in the sense of real error it will...
SQL Server transaction log, SHRINK - to be or not to be?
Published 24 May 7 8:42 AM |
SSQA.net
You have a production database which has a very high growth rate. As a result the database transaction log gets full resulting a daily scheduled job to shrink. All the times this is affecting the performance on SQL Server, what is the best option to shrink...
xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'
Published 24 May 7 8:5 AM |
SSQA.net
Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login...
Snapshot backups - do I need equivalent database size disk space?
Published 23 May 7 3:17 AM |
SSQA.net
Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
conference
database
databases
dmv
download
error
indexes
kba
management
microsoft
performance
query
replication
reporting services
security
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
October 2008 (3)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
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 for Posts
Atom
RSS for Comments
Email Notifications
Go