Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
November 2008 - 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
Row_number() Function with no specific order
Row_number() function is used to generate row number to rows based on the column which is ordered What if you want to generate row number without ordering any column Here is the method (Consider Suppliers table from northwind database) 1 Assign dummy...
Published
Sat, Nov 29 2008 4:42
by
SqlServer-QA.net
Filed under:
sql server
,
T-SQL
,
row number
SQL Server 2008 Analysis Services performance guide - process to go over
SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis...
Published
Thu, Nov 27 2008 11:34
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
mdx
,
monitoring
,
resources
,
Analysis Services
SQL Server 2008 Upgrade Technical Reference Guide Released
The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft...
Published
Wed, Nov 26 2008 4:11
by
SqlServer-QA.net
Filed under:
sql server
,
tools
,
upgrade
,
2008
UK Government Helps You - Beware its a SPAM*
With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are targeting the vulnerable users to obtain their personal details. Here I would like to present the...
Published
Wed, Nov 26 2008 2:33
by
SqlServer-QA.net
Filed under:
sql server
,
databases
,
best practices
,
beginners
,
spam
,
phishing
,
email
,
uk
,
government
SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008
Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version...
Published
Fri, Nov 21 2008 11:40
by
SqlServer-QA.net
Filed under:
sql server
,
high availability
,
best practices
,
database mirroring
,
usage
,
versions
Kilimanjaro - code name release for SQL Server!
The News is out for next SQL Server release!! During the Keynote presentation by Ted Kummert at PASS conference, Microsoft announced future capabilities for application and multi-server management as part of the SQL Server code-name “Kilimanjaro” release...
Published
Wed, Nov 19 2008 23:43
by
SqlServer-QA.net
Filed under:
sql server
,
microsoft
,
newt release
,
kilmanjaro
Cumulative Update #2 for SQL Server 2008 Released
Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us...( read more ) Read More...
Published
Tue, Nov 18 2008 5:09
by
SqlServer-QA.net
Filed under:
sql server
,
2008
,
support
,
cumulative update
Cumulative Update Package 2 for SQL Server 2008
Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one...
Published
Tue, Nov 18 2008 3:35
by
SqlServer-QA.net
Filed under:
sql server
,
package
,
download
,
version
,
hotfix
,
support
,
cumulative update
,
version 2008
SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?
PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility...
Published
Mon, Nov 17 2008 1:41
by
SqlServer-QA.net
Filed under:
sql server
,
perfmon
,
performance
,
dmv
,
dba
,
sysmon
,
performance monitoring
,
resource governor
,
new feature
Time Calculation on Numbers
In Forums sometimes I read questions on how to find out the difference between two times which are stored as float Here are some possible answers declare @t1 char ( 5 ), @t2 char ( 5 ), @sum float select @t1 = '12.56' , @t2 = '7.58' set...
Published
Sat, Nov 15 2008 3:18
by
SqlServer-QA.net
Filed under:
sql server
,
T-SQL
,
Time Calculation
RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008
In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to...
Published
Thu, Nov 13 2008 2:00
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
dba
,
best practices
,
troubleshoot
,
pssdiag
,
RML utilities
,
pssql
Temporary tables existence during Dynamic SQL usage in SQL Server
Here is an interesting question posted in the forums here asking about: Lots of time I face the problem with dynamic sql that I cant get the temporary table with data created through dynamic sql. for instance: SET NOCOUNT ON DROP TABLE Employee CREATE...
Published
Thu, Nov 13 2008 1:33
by
SqlServer-QA.net
Filed under:
sql server
,
insert
,
tempdb
,
tsql
,
dsql
,
dynamicsql
,
temporary table
Recover a database with no transaction log file - SQL Server 2005!
Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that...
Published
Tue, Nov 11 2008 1:16
by
SqlServer-QA.net
Filed under:
sql server
,
ssms
,
error log
,
suspect
,
2005
,
corrupted
,
detach
,
attach
,
dataabase
Jammin SQL Server 2008 - chalk talk type of meeting in Edinburgh
Here we go again, Scottish Area SQL Server User Group lined up another brain storming user group meeting on November 13th 2008 (Thursday) within Microsoft Edinburgh campus. For registration and more details about this jamming gotchas visit - SQLServerFAQ...
Published
Sun, Nov 9 2008 11:18
by
SqlServer-QA.net
Filed under:
sql server
,
microsoft
,
new features
,
meeting
,
usergroup
Scottish Area SQL Server User Group
I'm happy to announce that the next Scottish SQL Server User Group will be hosted at Microsoft Edinburgh on the evening of the 13th November. Full details of the agenda and how to register can be found on the UK Server User Group site here: http:...
Published
Thu, Nov 6 2008 17:53
by
SqlServer-QA.net
Filed under:
sql server
,
2008
,
User Group
The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications The cluster setup fails without a clear error message when you install a SQL Server 2008...
Published
Wed, Nov 5 2008 4:58
by
SqlServer-QA.net
Filed under:
sql server
,
kba
,
setup
,
error message
,
drive letter
,
failover cluster
SQL Server 2008 Cluster environment based KBAs
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications How to change SQL Server parameters in a clustered environment when SQL Server is not online...
Published
Tue, Nov 4 2008 1:55
by
SqlServer-QA.net
Filed under:
sql server
,
error
,
cluster
,
environment
,
parameter
,
failover
SQL Data Services (SDS) aka SQL Server Data Services (SSDS), fully equipped with stuff
SQL Data Services (SDS), formerly known as SQL Server Data Services (SSDS), are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server technologies and Windows Server, SDS provides highly available ,...
Published
Mon, Nov 3 2008 1:35
by
SqlServer-QA.net
Filed under:
sql server
,
data
,
new features
,
ssds
,
sds
,
container
,
sql server data services
,
cloud
SQL Server 2005 Multi-Site Clustering with Windows Server 2008
I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...
Published
Sun, Nov 2 2008 10:20
by
SqlServer-QA.net
Filed under:
sql server
,
high availability
,
2008
,
clustering
,
2005
SQL_VARIANT_PROPERTY function
If you want to know the datatype or length of a column , you can query on the system table syscolumns or system view INFORMATION_SCHEMA.COLUMNS But you dont need to query on system objects if you use SQL_VARIANT_PROPERTY function Example SELECT TOP 1...
Published
Sat, Nov 1 2008 4:47
by
SqlServer-QA.net
Filed under:
sql server
,
T-SQL
,
SQL_VARIANT_PROPERTY
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