Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
August 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
FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
Published
Fri, Aug 31 2007 11:41
by
SSQA.net
Filed under:
application
,
sql server
,
kba
,
stops
,
network
,
protocol
FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: “Can't find object <Object ID>”
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you display a report that uses SAP Business Information...
Published
Fri, Aug 31 2007 11:25
by
SSQA.net
Filed under:
sql server
,
business
,
kba
,
service pack2
,
reporting services
,
information
,
data source
,
sap
Unable to start SQL Server service with a specific certificate?
You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a...
Published
Fri, Aug 31 2007 8:05
by
SSQA.net
Filed under:
sql server
,
performance
,
security
,
services
,
certificate
,
start
,
ssl
,
http
Problem with migrating database from a SQL Server Evaluation edition to a purchased version
During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling...
Published
Fri, Aug 31 2007 5:25
by
SSQA.net
Filed under:
sql server
,
database
,
upgrade
,
update
,
edition
,
install
,
evaluation
,
uninstall
Information and issues with Kerberos security within SQL Server 2005?
What is the Kerberos Authentication? What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters...
Published
Fri, Aug 31 2007 4:45
by
SSQA.net
Filed under:
sql server
,
security
,
windows
,
audit
,
clustering
,
authentication
,
failover
,
kerberos
Failed to claim unused space with SP_SPACEUSED?
Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name...
Published
Fri, Aug 31 2007 4:09
by
SSQA.net
Filed under:
sql server
,
database
,
dbcc
,
dba
,
space
,
table
,
transact sql
,
data type
,
delete
How many DBAs you need to manage show in multi-server environment?
This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed...
Published
Thu, Aug 30 2007 17:24
by
SSQA.net
Filed under:
sql server
,
server
,
services
,
dba
,
edition
,
multiple
How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions
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 How to enable the SQL Server 2005 Integration...
Published
Thu, Aug 30 2007 14:56
by
SSQA.net
Filed under:
sql server
,
integration
,
ssis
,
services
,
kba
,
process
,
file
,
dump
,
exception
FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report"
Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View...
Published
Thu, Aug 30 2007 13:48
by
SSQA.net
Filed under:
sql server
,
kba
,
reporting services
,
grey
,
toolbar
,
view report
FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: “BCP host-files must contain at least one column”
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Published
Thu, Aug 30 2007 13:45
by
SSQA.net
Filed under:
sql server
,
kba
,
service pack2
,
column
,
bcp
,
queryout
FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Published
Thu, Aug 30 2007 13:42
by
SSQA.net
Filed under:
sql server
,
query
,
plan
,
kba
,
service pack2
,
processor
Audit the activity such as SELECT statements - CDC
Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in...
Published
Thu, Aug 30 2007 6:02
by
SSQA.net
Filed under:
sql server
,
microsoft
,
security
,
audit
,
2008
,
cdc
,
monitoring
,
select
Number of databases limit for Database Mirroring within X64 environment?
We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...
Published
Thu, Aug 30 2007 5:27
by
SSQA.net
Filed under:
sql server
,
performance
,
high availability
,
server
,
database mirroring
,
x64
,
geographic
Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?
No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000...
Published
Thu, Aug 30 2007 5:02
by
SSQA.net
Filed under:
sql server
,
performance
,
databases
,
technet
,
benchmark
,
upgrade
,
version
,
best practices
,
compatibility
FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Published
Thu, Aug 30 2007 5:00
by
SSQA.net
Filed under:
sql server
,
performance
,
update
,
query
,
kba
,
service pack
,
operation
FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Published
Wed, Aug 29 2007 14:38
by
SSQA.net
Filed under:
sql server
,
error
,
kba
,
service pack
,
exception
,
unhandled
,
dtaengine
How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications How to reduce paging of buffer pool memory in the 64-bit version of SQL Server...
Published
Wed, Aug 29 2007 13:09
by
SSQA.net
Filed under:
sql server
,
memory
,
kba
,
x64
,
buffer pool
,
paging
FIX: You receive an error message when you try to install the original release version of SQL Server 2005 or SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications...
Published
Wed, Aug 29 2007 12:31
by
SSQA.net
Filed under:
sql server
,
windows
,
kba
,
vista
,
service pack
,
1
TSQL to detect long running queries against the database
When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id...
Published
Wed, Aug 29 2007 6:37
by
SSQA.net
Filed under:
sql server
,
performance
,
databases
,
query
,
tsql
,
running
,
long
ASYNC_NETWORK_IO: query is slow
When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the...
Published
Wed, Aug 29 2007 5:00
by
SSQA.net
Filed under:
sql server
,
performance
,
tuning
,
i/o
,
object
,
disks
,
type
,
wait
1
2
3
4
5
Next >
...
Last »
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