Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
November 2007 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Blogs
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Windows Azure platform and SQL Server 2008 R2 feature complete CTP is available for download
SQL Server 2008 features that work only in Enterprise Edition
SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!
I am a forum spammer! Delete my account immediately!!
SQL Server upgrade practices - choose optimal upgrade options
Tags
2005
2008
best practice
best practices
community
conference
database
databases
dba
dmv
download
error
indexes
kba
microsoft
performance
query
replication
security
sql server
ssis
ssms
tsql
T-SQL
webcast
View more
News
Archives
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
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)
Sort by:
Most Recent
|
Most Viewed
|
Most Commented
Select columns from (EXEC Procedure_name) - Is this possible?
Well.I see many users asking this question in forums. "I have a procedure that returns single resultset. How do I filter the result returned from the procedure? There are, at least, two ways to acheive this Let us create this procedure create procedure...
Published
Mon, Nov 26 2007 6:54
by
SSQA.net
Filed under:
sql server
,
procedure
,
openrowset
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?
Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007...
Published
Fri, Nov 23 2007 8:51
by
SSQA.net
Filed under:
sql server
,
package
,
microsoft
,
update
,
sp2
,
best practices
,
hotfix
,
service pack2
,
testing
,
cumulative
Tuning options for SQL Server 2005 that is running in high performance workloads
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Published
Thu, Nov 22 2007 16:28
by
SSQA.net
Filed under:
performance
,
database mirroring
,
workload
,
sql serverkba
,
high performance
Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when you try to replicate...
Published
Wed, Nov 21 2007 16:25
by
SSQA.net
Filed under:
sql server
,
replication
,
error
,
kba
,
hresult
,
mobile edition
FIX: All later commands are ignored after the SQLDescribeParam function returns an error message in a SQL Server 2005-based application that uses the SQL Native Client ODBC provider
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Published
Wed, Nov 21 2007 15:12
by
SSQA.net
Filed under:
sql server
,
kba
,
odbc
,
communication
,
native client
,
sqldescribe
,
parameters
You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Published
Tue, Nov 20 2007 15:09
by
SSQA.net
Filed under:
sql server
,
kba
,
enterprise
,
encryption
,
client
,
x64
,
xp
,
127.0.0.1
Random Password Generator
This is one of the methods to generate 8 chracters password randomly (combination of alphabets,numbers and special characters) declare @password varchar(8) set @password='' select @password=@password+char(n) from ( select top 8 number as n from...
Published
Tue, Nov 20 2007 7:29
by
SSQA.net
Filed under:
sql server
,
random password
SQL Server 2008 November CTP 5 - next instalment is available
Here comes another instalment of SQL Server 2008 for the CTP fans. The SQL Server 2008 November CTP has been released to the connect.microsoft.com website and is available for download here . One of the improvements in this build is the ability to persist...
Published
Tue, Nov 20 2007 2:49
by
SSQA.net
Filed under:
sql server
,
microsoft
,
community
,
2008
,
connect
,
spatial
,
best practice
,
business intelligence
,
filestream
,
ctp5
Installing SQL Server Integration Services on 64-bit Computers
I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform...
Published
Mon, Nov 19 2007 8:29
by
SSQA.net
Filed under:
sql server
,
microsoft
,
ssis
,
download
,
dts
,
database mirroring
,
x64
,
etl
,
integration services
,
compatability
,
backward
You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Published
Sun, Nov 18 2007 15:15
by
SSQA.net
Filed under:
sql server
,
error
,
kba
,
import
,
table
,
x64
,
wizard
,
export
FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Message when you click the Back button in Internet Explorer 7 to return...
Published
Sat, Nov 17 2007 15:16
by
SSQA.net
Filed under:
datetime
,
sql server
,
kba
,
reporting services
,
report
,
version7
,
internet explorer
List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition
The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...
Published
Fri, Nov 16 2007 17:14
by
SSQA.net
Filed under:
sql server
,
restore
,
database
,
kba
,
service pack2
,
x64
,
backups
,
modified
FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: An empty string is replicated as...
Published
Fri, Nov 16 2007 15:05
by
SSQA.net
Filed under:
sql server
,
replication
,
kba
,
table
,
2005
,
compact edition
,
synchronization
SQL Server: How do I identify the queries that are worth tuning?
Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...
Published
Fri, Nov 16 2007 7:02
by
SSQA.net
Filed under:
sql server
,
performance
,
management
,
microsoft
,
blogs
,
technet
,
dmv
,
dba
,
best practice
,
slow query
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...
Published
Fri, Nov 16 2007 4:53
by
SSQA.net
Filed under:
sql server
,
restore
,
high availability
,
backup
,
security
,
upgrade
,
best practices
,
cluster
,
2000
,
2005
,
detach
,
attach
,
data files
,
logins
Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when you connect to a named...
Published
Fri, Nov 16 2007 0:18
by
SSQA.net
Filed under:
sql server
,
error
,
kba
,
longhorn
,
vista
,
named instance
,
server not found
,
windows server 2008
FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual...
Published
Thu, Nov 15 2007 15:02
by
SSQA.net
Filed under:
sql server
,
error
,
kba
,
view
,
oledb
,
visual foxpro
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...
Published
Thu, Nov 15 2007 9:41
by
SSQA.net
Filed under:
sql server
,
performance
,
microsoft
,
server
,
tuning
,
dbcc
,
system
,
best practice
,
testing
,
resources
,
sqlperf
,
max worker threads
Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)
It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...
Published
Thu, Nov 15 2007 7:16
by
SSQA.net
Filed under:
sql server
,
performance
,
microsoft
,
technet
,
dmv
,
top
,
tsql
,
reads
,
system resources
,
expensive query
,
identity
,
writes
CHECKDB From Every Angle: How long will CHECKDB take to run?
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...
Published
Wed, Nov 14 2007 22:22
by
SSQA.net
Filed under:
performance
,
dbcc
,
disaster recovery
,
Database Maintenance
,
CHECKDB From Every Angle
,
Corruption
1
2
3
Next >
Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.
zines:andrewbelon.com