SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
December 2007 - Posts
10 Best Practices for Data Archiving - all platforms
Published 31 December 7 6:44 AM |
SSQA.net
When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in...
Remove duplicate characters from a string
Published 29 December 7 1:13 AM |
SSQA.net
Pinal Dave in his weblog posted about Remove Duplicate Chars From String Here is its alternate method with Number table approach create procedure remove_duplicate_characters ( @string varchar ( 100 )) as Declare @result varchar ( 100 ) set @result = ''...
SQL Server 2005 Reporting Services best resource for beginners
Published 28 December 7 6:0 AM |
SSQA.net
What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal...
SQL Server 2005 memory configuration gotchas
Published 28 December 7 4:44 AM |
SSQA.net
This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that...
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
Published 27 December 7 6:35 AM |
SSQA.net
Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo . Catalog CT INNER JOIN dbo . DataSource DS ON CT . ItemID = DS . ItemID Where Type = 2 Order by DataSourceName , ItemName...( read more ) Read More.....
Idera giving holiday gift to SQL Server users - free copy of SQL Job Manager
Published 27 December 7 4:3 AM |
SSQA.net
A special “holiday gift” offer for a free copy of SQL job manager at http://www.idera.com/ Offer expires December 31st. SQL job manager is Idera's next generation solution for scheduling and managing SQL Server jobs across the enterprise. Designed...
SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!
Published 27 December 7 2:2 AM |
SSQA.net
From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...
How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008
Published 24 December 7 4:38 PM |
SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL...
SQL Server undocumented stored procedure to get information on login mapping name
Published 24 December 7 6:55 AM |
SSQA.net
They say better not to use UNDOCUMENTED stored procedures, which is true in the aspect when any Service Pack or version is released that may not be included and your task might have issues in working out. Similar to this I was going through various methods...
SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!
Published 24 December 7 4:42 AM |
SSQA.net
From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...
SQL Server- TSQL to see which object reside under which file groups?
Published 24 December 7 4:40 AM |
SSQA.net
To continue the FIND-FilegroupFull post on the filegroups, here is the most common question on the forums to get which object reside under which filegroup if there are multiple ones associated: select si.rows as 'Rows', SO.Name as Table, SI.name...
How to install Analysis Cubes for Microsoft Dynamics GP
Published 23 December 7 4:33 PM |
SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to install Analysis Cubes for Microsoft Dynamics GP http://support.microsoft...
FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"
Published 23 December 7 1:59 PM |
SSQA.net
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 jump to another report that uses a shared data...
Scottish Developers - Gary Short's Favourite Design Patterns
Published 21 December 7 3:59 PM |
SSQA.net
If you've heard of design and enterprise patterns and want to find out a bit more... What: Lecture Host: Scottish Developers When: Wednesday, January 16 at 7:00pm Where: CPDC, Glasgow Caledonian University RSVP & More information: http://www.scottishdevelopers...
SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
Published 21 December 7 7:47 AM |
SSQA.net
As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic...
We wish you Happy Holidays - Merry Christmas and New Year !!!
Published 21 December 7 6:29 AM |
SSQA.net
Merry Christmas .... HAPPY NEW YEAR... whatever makes your wish come true! Wish you HAPPY HOLIDAYS and be safe/have fun during this season............ Thanks for all the support and registering here.... hope you find this site useful for your tasks.....
Count number of words in a String
Published 21 December 7 3:55 AM |
SSQA.net
Tony Rogerson in his weblog posted about Counting the number of words in a string Here are two more methods 1 Using the method I posted already about Squeeze Function to remove multiple spaces Declare @s varchar ( 100 ) set @s = ' See how many words...
TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?
Published 21 December 7 3:34 AM |
SSQA.net
Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...
SQL Server ETL Performance during Data Load Optimization
Published 20 December 7 8:40 AM |
SSQA.net
Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL...
How to find which types [32bit or 64bit] and versions of SQL Server can be installed?
Published 20 December 7 8:9 AM |
SSQA.net
As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will support X64 based installations. IN the same manner it is a common question out in the newsgroups referring to which types and versions of SQL Server...
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