SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
July 2008 - Posts
Licensing - what is Microsoft's stand on public licensing when it comes to Open Source software?
Published 31 July 8 4:8 AM |
SSQA.net
It is a compulsory requirement that you need a license to work/operate a software application. That means it is required for each physical or virtual processor accessed by an operating system environment running such a software. I must admit Licensing...
SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages
Published 31 July 8 3:10 AM |
SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages...
SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests
Published 30 July 8 11:43 AM |
SSQA.net
As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite...
RC0 reporting services product samples - SQL Server 2008 and 2005
Published 30 July 8 10:1 AM |
SSQA.net
Until SQL Server 2000 the sample databases or files are installed along with binaries & program files, since version 2005 this has been changed and they are available from Microsoft download site and SQL Server Reporting Services (SSRS) has no exclusion...
SQL Server 2005 supportability on virtual environment
Published 30 July 8 3:39 AM |
SSQA.net
Virtualization and Consolidation is still a hot topic and revising SQL Server consolidation and virtualization - hot topic in the industry related post here that you can easily manage the resources by using virtual machine technology that enables multiple...
How to troubleshoot SQL Server 2008 Setup issues
Published 30 July 8 3:9 AM |
SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot SQL Server 2008 Setup issues http://support.microsoft.com/kb/955396...
Get Control - Sharepoint Management with IDERA's PointAdmin tool!
Published 29 July 8 5:10 PM |
SSQA.net
Introducing Idera's Point admin toolset BETA : 10 Tools To Simplify SharePoint Management Idera is pleased to announce our new SharePoint management tool, the Point admin toolset (TM) , is now in BETA and ready for download! If you're faced with...
Outputting DBCC results
Published 26 July 8 6:29 AM |
SSQA.net
Sometimes it may be useful to reuse the result of the DBCC commands. If the DBCC command resturns a resultset, it can be outputted to a table. Consider the following command DBCC useroptions It returns a single resultset. To copy the resultset to a table...
SQL Server data and log files initialization, think multiple files, backup & restore performance!
Published 25 July 8 6:1 AM |
SSQA.net
Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...
CLR Stored Procedures - handling security on SQL Server side
Published 24 July 8 3:52 AM |
SSQA.net
Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework...
Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel video available to view
Published 22 July 8 6:37 AM |
SSQA.net
In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build...
SQL Server Business Intelligence - handling data mining and mission critical applications
Published 22 July 8 4:31 AM |
SSQA.net
Data, data and data everywhere: a typical scenario for an Enterprise DBA to handle the mission critical applications and comprehensive information across the organization using SQL Server technologies. Since the inception of SQL Server 2005 version Business...
Ordering Interger values stored in Varchar column
Published 21 July 8 9:21 AM |
SSQA.net
I have seen many newbies asking "How do I sort the numbers stored in varchar columns?" Here are some methods declare @t table ( data varchar ( 15 )) insert into @t select '6134' union all select '144' union all select '7345'...
Cumulative Update 8 package for SQL Server 2005 Service Pack2
Published 16 July 8 4:50 AM |
SSQA.net
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...
DTS Packages migration webinar - get tips and tricks from a MVP
Published 15 July 8 10:44 AM |
SSQA.net
Brian Kinight is well known SQL Server Professional in the community, every user will know about SQL Server Central website which was founded by him. Join Brian to discuss the strategies of upgrading DTS packages to SQL Server Integration Services (SSIS...
Varchar(max) datatype and Replicate function
Published 15 July 8 8:54 AM |
SSQA.net
As you know, Replicate function is used to repeat a character expression for a specified number of times. But by default the result is converted to varchar of maximum size 8000 when you dont convert the expression to specific type Consider the following...
Get ready for SQL Server 2008 RTM release!
Published 14 July 8 9:56 AM |
SSQA.net
Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 is set to RTM'd during the month of August 2008, as per Bob...
TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005
Published 14 July 8 5:26 AM |
SSQA.net
DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10 total_logical_reads...
Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005
Published 11 July 8 4:38 AM |
SSQA.net
SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know...
Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.
Published 10 July 8 3:2 AM |
SSQA.net
As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the...
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
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
September 2008 (9)
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