|
|
Get SqlServer-QA.net delivered by email
 NEW! - Remote Monitoring & DBA Services
Front Page News
-
|
Whenever the new version of SQL Server is released the first thing I search for Books Online update to upgrade the local copy. In similar to that Microsoft have been releasing lot of free resources and tools that can enhance the learning experience for...
|
-
|
Here are few free tools and references to download that can enhance the Visual Studio 2010 knowledge: Visual Studio 2010 and .NET Framework 4 Training Kit Brief Description June 2010 Release of the Visual Studio 2010 and .NET Framework 4 Training Kit...
|
-
|
This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to...
|
-
|
While we talked about list of sessions and vote on interested ones: http://sqlserver-qa.net/blogs/etc/archive/2010/07/19/9329.aspx here is hte news for you to register for this SQLBits 7 - The 7 Wonders of SQL conference, even bigger and better. SQLBits...
|
-
|
It is a common question that a particular stored procedure is executing for a long time and sometimes looks like it is hanging for longer time. This will cause if you have a trigger looping for the stored procedure actions and using following TSQL you...
|
-
|
Sometimes back, my friend told me that they had an application where users update their timesheets. He suspected that some users who had access to the database directly update some entries. He wanted to know whether some users update entries using a query...
|
-
|
I have been playing with FILESTREAM backups for a book that I am writing and came across something that I did not really like. I observed that a FILESTREAM backup may include garbage files which gets restored along with the database. What are garbage...
|
-
|
Both these functions are used to convert values from one datatype to another But there are some differences between them 1 CAST is ANSI standard and CONVERT is specific to SQL Server 2 CAST can't be used for formating purposes. But CONVERT can be...
|
-
|
Download and test the latest instalment of cumulative Update 9 for SQL Server 2008 Service Pack 1 which consist the hotfix release related to SQL Server 2008 version and fix to the issues since the release of Service Pack 1. The build number for this...
|
-
|
Back until SQL Server 2005 days there was a high demand for third party tools and scripts to collect the data based upon the requirement, analyze and produce a report. SQL Server 2008 gets you Management Data Warehouse, a relational database that contains...
|
-
|
I had to answer bunch of questions around version number and fixes that are released for SQL Server 2005 & 2008, during a SQL Server platform health check for a client yesterday.. First one was, what is easy way to determine which version (service...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications Error message when you try to install a SQL Server 2008 cumulative update or service pack:...
|
-
|
The question is tricky as the answer too! Online index operation (Enterprise Edition specific) is the new addition in SQL Server 2005, the simple operation behind the scenes will be preparation, build and final, it is possible to perform the concurrent...
|
-
|
Another interesting question & replies on SSP forums lead to this post: Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two enviorments. something like if @@version = 'Microsoft Sqlserver...
|
-
|
Often people ask how to use InitCap function in SQL Server Initcap is used to capitalise each first letter of the word and keep rest as non-capital Pinal Dave has a post at http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case...
|
-
|
Here comes the 7 wonders of SQL conference - SQL Bits 7, this will take place from September 30 to October 02 2010 at York University . No doubt that SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established...
|
-
|
BACKUPS are key to recover the data during the disaster recovery, but many times just taking backups is not sufficient as you need to ensure the backups are good enough with no corruption. The subject line message though classified as an information message,...
|
-
|
PROFILER is very handy tool to trace the events on SQL Server, like wise SQL Server 2008 gets the new feature Extended Events which is a light-weight & less intrusive tool. Still there are number of DBAs out there are really scared to invoke PROFILER...
|
-
|
That is the question from SSP forums asking about the internal representation of data types in SQL Server. Here is further explanation for that questions where I picked up new information too. Back to the basics, that all the data that needs to be stored...
|
-
|
Talking about SQL Server Reporting Services, since SQL Server 2005 version there has been a better enhancements to the service. The setup will allow to install a report server as a windows server services as a seperate application domain and not associated...
|
-
|
Database Mirroring setup is quite easy between the SQL Server instances when you don't have any pre-configured setup on network or service accounts. But there are certain pre-requisites that you need to be sure about database mirroring setup and resolve...
|
-
|
Not that every time I recommend to disable any constraints on the database, but there are times when you may need to temporarily relieve the referential integrity checks of one or more foreign keys, such as when you're performing a large number of inserts...
|
-
|
The symbol dot (.) plays a major role when you write queries It is mainly used to speicify the columns for the respective tables when a join is used as you see in the following example select t1.col1,t1.col2,t2.col3,t2.col4 from table1 as t1 inner join...
|
-
|
SQL Server 2008 R2 and Windows Server 2008 R2 has opened up new dimension of physical resource usage and limitations. As you may be aware Windows Server 2008 R2 is only available in 64-bit edition, having the features that are related to DB engine are...
|
-
|
Here is the reminder for the organisations and users about Windows XP mainstream support from Microsoft Lifecycle services: As we announced in 2008, support for Windows XP Service Pack 2 (SP2) will end on July 13, 2010. Support for Windows 2000 will end...
|
|
|
|