During a recent discussion within a local User Group I have been asked with the above question that where can I get list of User Group information for Microsoft Technologies. Please find the following list of Usergroups that are convened within geographical region of United Kingdom [ Source: UK usergroup...
Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a reference: http://sqlserver-qa.net/blogs/etc/archive/2007/03/17/sql-server-open...
If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by using the TSQL SET statements such as SET SHOWPLAN_XML...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-04-2008
Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan
One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the SQL Server database and better that t hese images...
I feel this type of contest by Microsoft will make this (2008) SQL Server release as a best release as more and more users will be interested to j oin the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules that govern how the Microsoft SQL Server...
The 11th annual DevWeek conference, the UK's biggest dedicated event for software developers, features a choice of 16 all-day workshops and over 70 breakouts sessions on a wide range of topics, including .NET Framework 3.5, Silverlight, WCF, Visual Studio 2008, ASP.NET AJAX, SQL Server 2008, LINQ...
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-01-2008
Filed under: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures
As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage. From the changes (upgrade) to the Operating System and SQL Server we now have new set of SQL Server Integration Services counters. Among them...
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, in this regard review the blogs by SQLQuery...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-25-2008
Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation
Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to the SQL Express engine? Any memory limitations and...