SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
March 2008 - Posts
SQL Server 2008 - TSQL behavioural changes and enhancements
Published 31 March 8 2:0 PM |
SSQA.net
As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...
MVP Global Summit - where all the attendees are coming from, view map geographically?
Published 31 March 8 3:1 AM |
SSQA.net
MVP Global Summit, what it meant for MVPs? At one place, global connections with peers with a shared insight with a flavour of engagement with relevant product manager, sounds terrific isn't it! Who can attend - as per the previous post on MVP Global...
Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform
Published 28 March 8 6:45 PM |
SSQA.net
Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...
Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?
Published 28 March 8 4:31 AM |
SSQA.net
Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings...
Free! Get 5GB online storage with SkyDrive
Published 27 March 8 4:35 PM |
SSQA.net
Well I'm not promoting any product here, but amused to see the email I have got from Microsoft on using Windows Live services. I can say this is true offerring and easy to access your files wherever you are, your data - any time any place! . Forget...
Web Seminar: True High Availability for SQL Servers
Published 27 March 8 4:27 AM |
SSQA.net
Another sponsored link I have got from Windows magazine: When: Thursday March 27, 2008 12:00 PM EDT Register today! (now) Simply put, your critical applications use SQL. It is the silent engine behind the curtains doing the heavy and important work keeping...
SQL Server Clustering get pre-installation information and choose the best practices for your environment
Published 27 March 8 3:40 AM |
SSQA.net
Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
Published 26 March 8 3:1 AM |
SSQA.net
Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...
Strategy with SQL Server and Sharepoint together
Published 25 March 8 4:50 AM |
SSQA.net
Managing SharePoint is about more than just backup, recovery, administration, or migration. An effective SharePoint strategy means being proactive, scrutinizing the entire platform (including SQL Server), and reducing your vulnerability. This white paper...
Best Practices for Deploying SharePoint in a Global Enterprise
Published 21 March 8 8:7 AM |
SSQA.net
Learn about key business drivers facing organizations as they architect their global SharePoint infrastructure. This seminar’s focus will be on providing global agility and improved remote connectivity to critical business data. Infonic’s Geo-Replicator...
SQL Server 2008 Spatial data - geography & geometry, all in one
Published 20 March 8 3:32 AM |
SSQA.net
Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric...
Various blog links for sharepoint and office products
Published 19 March 8 7:32 AM |
SSQA.net
Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...
MOSS Tables - Usage Reporting
Published 19 March 8 2:0 AM |
SSQA.net
http://suguk.org/blogs/sharepointhack/archive/2008/03/17/9161.aspx...( read more ) Read More...
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions
Published 18 March 8 6:23 AM |
SSQA.net
You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...
SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?
Published 18 March 8 4:20 AM |
SSQA.net
First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...
Using the Filter Feature in InfoPath web forms
Published 18 March 8 1:4 AM |
SSQA.net
There is a great feature in infopath - Filter. Unfortunately this Feature is not available in Web Forms. Here ia a way to simulate this functionality. 1. The first step is to create a new form in infopath and add 2 Data Connection. 2. The First Connection...
Developer Day Scotland - mark your diaries for 10 May 2008 -Delegate registrations are now open!
Published 17 March 8 9:59 AM |
SSQA.net
With regard to the subject the delegate registration is now open: To register please visit: http://developerdayscotland.com/main/DelegateRegistration/tabid/69/Default.aspx To see the finalised agenda please visit: http://developerdayscotland.com/main...
Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.
Published 17 March 8 4:39 AM |
SSQA.net
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...
SQL Server 2008 - What's new and what's coming up!
Published 17 March 8 3:11 AM |
SSQA.net
You may be aware that MVP s have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award...
Splitting csv to columns
Published 15 March 8 6:10 AM |
SSQA.net
Suppose you have string in csv format and want to split into seperate columns. You can use parsename function as long as you have maximum four values. The following would work for any number of values declare @s varchar ( 2000 ), @data varchar ( 2000...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
database
databases
dmv
download
error
high availability
indexes
kba
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
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