SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
July 2007 - Posts
MSDN events calender for the month of August 2007 in USA
Published 31 July 7 12:31 PM |
SSQA.net
Upcoming MSDN events in your area: August 9 - Portland, OR Meet Your Fellow Masters with MSDN Events Connect with like-minded coders at this free, half-day of learning from MSDN Events. • Session 1: New Thinking in Data with LINQ and Visual Studio 2008...
Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections
Published 31 July 7 12:27 PM |
SSQA.net
Event: Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections When: November 5 - 8, Las Vegas, NV Dive hard into current and future releases from...
Table fragmentation, Index contention and locking issues to resolve
Published 31 July 7 9:31 AM |
SSQA.net
Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to...
TSQL to identify the transaction with the most locks
Published 31 July 7 9:25 AM |
SSQA.net
SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Read More...
Error: An attempt was made to send an email when no email session has been established.
Published 31 July 7 4:51 AM |
SSQA.net
What to do when you get the error specified on the subject above? You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also...
Performace overhead and resolution when using CLR vs TSQL
Published 31 July 7 3:42 AM |
SSQA.net
Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds...
Best and Worst of having indexed views in SQL 2005
Published 30 July 7 10:15 AM |
SSQA.net
Consider to have indexed view if the queries are accessing using a f requently occurring aggregations and joins. Irrespective of whether or not a query is asked frequently, it may be a candidate for an indexed view if it takes significant time to answer...
How to gain Disk related performance with few simple steps
Published 30 July 7 9:24 AM |
SSQA.net
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write...
Reporting Services: Images are not showing properly when deployed on the live server?
Published 30 July 7 6:10 AM |
SSQA.net
Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that...
How to find whether Sql Server 2005 x86 is installed or x64 is installed?
Published 29 July 7 9:36 AM |
SSQA.net
Say you have multiple instances of SQL Server and on mixed platforms such as 32 bit and X64 bit platforms, so how do you find which version of SQL you have installed. If you are well versed with the environment then by looking at the servernames you can...
TSQL to generate a script that updates a column on every table in my database. How do I do this?
Published 29 July 7 3:39 AM |
SSQA.net
SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + '...
Unused indexes on a database, its good and bad
Published 27 July 7 8:51 AM |
SSQA.net
You may be aware that the indexes on a SQL Server database take up space, so in case of unused indexes its obvious that they waste storage. It is easy to find the indexes using SP_HELPINDEX statement against a table, so to identify the unused indexes...
Why is a SPID blocking itself in sysprocesses?
Published 27 July 7 3:29 AM |
SSQA.net
This was the question asked during an interview that was attended by one of my friend, I'm not sure how he managed to answer but came to me asking how it is possible. For your information af ter you apply SQL 2000 Service Pack 4, you might observe...
TSQL to generate blocking scenario for testing
Published 27 July 7 2:44 AM |
SSQA.net
Most of the times you have observed to identify the blocking and how to resolve them. How about you need a script to generate a blocking scenario within your queries, this is to identify the blocker script is working or not. Also will help to test whether...
TSQL to find computed column expression columns
Published 27 July 7 2:34 AM |
SSQA.net
USE <dbname>; GO SELECT OBJECT_NAME(d.referenced_major_id) AS referenced_name ,COL_NAME(d.referenced_major_id, d.referenced_minor_id) AS referenced_columns ,OBJECT_NAME(referenced_major_id) AS dependent_object_name ,COL_NAME(d.object_id, d.column_id...
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)
Published 26 July 7 7:49 AM |
SSQA.net
Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider...
Full Text Search is installed, but not enabled to see at table-level
Published 26 July 7 4:38 AM |
SSQA.net
It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance...
Better way to handle and validate IP Address data column
Published 26 July 7 3:34 AM |
SSQA.net
One of the developer asked a question to handle and parse the IP Address data on a table, as you are aware IP Address data would have 4 sections and to parse each 4-part value is requried for reduce any duplication. You could take hlep of SUBSTRING and...
TSQL to get FieldName & FieldDescription within a SQL Server database
Published 25 July 7 9:52 AM |
SSQA.net
When you are documenting a database including the table-column information you need to have a description that can specify that so and so column is used for such a purpose. Think about accessing such information using Enterprise Manager or SS Management...
/3GB /PAE and AWE blurb what is it you hear within your environment?
Published 25 July 7 9:6 AM |
SSQA.net
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
database
databases
dmv
download
error
high availability
indexes
kba
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
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