SqlServerKudos

SQL Server

1
kudos

Kudos

List of free resources and tools specific to SQL Server 2008 R2

published 4 hours, 34 minutes ago posted by

sa 1 day, 5 hours, 33 minutes ago

List of free resources and tools specific to SQL Server 2008 R2

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 Developers, DBA and Architects. So here are few resources that I would like to refer about R2 product specific: SQL Server 2008 R2 Feature Pack This R2 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server...(re... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: .net4, Developer, Documentation, download, feature pack, learning, SharePoint, SQL Server, SQL Server 2008 R2, Version

1
kudos

Kudos

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

published 4 hours, 34 minutes ago posted by

sa 2 days, 4 hours, 58 minutes ago

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

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 Visual Studio 2010 Keybinding Posters Brief Description Reference posters for the default keybindings in Visual Studio 2010 for Visual Basic, Visual C#, Visual C++ and Visual F# .NET Framework 3.5 Common Namespaces and Types Poster Brief Description...(read ... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: developer kit, dotnet 4.0, feature pack, free, learning, report builder, SQL Server, SQL Server 2008 R2, technical learning, Training, visual studio 2010

1
kudos

Kudos

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

published 4 hours, 34 minutes ago posted by

sa 2 days, 6 hours, 3 minutes ago

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

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 basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, DBA, disk space, free space, log writer, size, SQL Server, transactionon log, vlf

1
kudos

Kudos

SQL Bits 7 - Registrations now open

published 4 hours, 34 minutes ago posted by

sa 3 days, 1 hour, 19 minutes ago

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 7 will take place over three days from Thursday September 30th to Saturday October 2nd. Day one will be a training day, featuring in-depth full day seminars by leading SQL Server professionals such as Brent Ozar and Buck Woody (see http://www.sqlbits.com/... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, community, Conference, SQL Server, SQL Server 2008 R2, SQLBits, Training

1
kudos

Kudos

Backup of a FILESTREAM database may include garbage files as well

published 4 hours, 34 minutes ago posted by

sa 3 days, 3 hours, 29 minutes ago

Backup of a FILESTREAM database may include garbage files as well

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 Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #FILESTREAM, filestream, SQL Server, TSQL

1
kudos

Kudos

Stored procedure hangs, how to tell which statement is currently running?

published 4 hours, 34 minutes ago posted by

sa 3 days, 5 hours, 39 minutes ago

Stored procedure hangs, how to tell which statement is currently running?

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 can find which statement is current running or rather you are assuming it is hanging for long time: -- For the best results see the results to Text (CTRL +T before execution) DECLARE @Handle binary(20), @start int, @end int, @SPID int SET @SPID = spid...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: current, execution, hang, SQL Server, stored procedure, TSQL

1
kudos

Kudos

List of KBA links updated specific to SQL Server 2008

published 4 hours, 34 minutes ago posted by

sa 9 days, 2 hours, 54 minutes ago

List of KBA links updated specific to SQL Server 2008

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 patch installer has failed to update the shared features" http://support.microsoft.com/kb/2216468/en-US New 7/8/2010 8:33:00 AM GMT Error message when you try to open a project in SQL Server 2008: "The located assembly's manifest definition...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: configuration, cumulative update, fulltext, kba, service broker, SQL Server

1
kudos

Kudos

Cumulative update package 9 for SQL Server 2008 Service Pack 1

published 4 hours, 34 minutes ago posted by

sa 9 days, 3 hours, 59 minutes ago

Cumulative update package 9 for SQL Server 2008 Service Pack 1

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 CU9 package is 10.00.2789.00. and KBA970365 gets you the list of builds since SQL Server 2008 SP1 release: Build 10.00.2775 (cumulative update) - CU8 Build 10.00.2770 & Build 10.00.2769 - interim fixes Build 10.00.2766 (cumulative update) - CU7 Build...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, ctp, cumulative update, deadlock, package, Performance, release, SQL Server, Testing, trace flag

1
kudos

Kudos

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

published 4 hours, 34 minutes ago posted by

sa 9 days, 5 hours, 4 minutes ago

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

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 pack release) of SQL Server is running :As 2000 version is still operational (most of the places) I would say run the following TSQL against the registered SQL instances on your network: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),.... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, ctp, download, fix, service pack2, SQL Server, versions

1
kudos

Kudos

SQL Server Management Data Warehouse 3 data collectors - useful facts

published 1 day, 4 hours, 38 minutes ago posted by

sa 9 days, 6 hours, 9 minutes ago

SQL Server Management Data Warehouse 3 data collectors - useful facts

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 the data that is collected from a server using the new SQL Server 2008 data collection mechanism - BOL is your best friend to get to know more on introduction & How-To in specific to Management Data Warehouse. As it referred it only works from...(read m... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, data collector, management data warehouse, performance monitoring, schedule, SQL Server, sqlagent

1
kudos

Kudos

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

published 1 day, 4 hours, 38 minutes ago posted by

sa 11 days, 4 hours, 24 minutes ago

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

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 online index DDL operation on the same table or views when you are creating multiple nonclustered indexes (new) and in same case of reorganizing such nonclustered indexes. But you cannot simply create another index ONLINE when another index online...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, event class, Indexes, online, profiler, rebuild, SQL Server, trace

1
kudos

Kudos

Execute a script based on SQL Server version?

published 2 days, 4 hours, 43 minutes ago posted by

sa 11 days, 6 hours, 34 minutes ago

Execute a script based on SQL Server version?

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 2000' --do this if @@version ='Microsoft Sqlserver 2008' -- do this ----------------------Reply On the syntax side, just remember that you can use LIKE and wildcards in any string comparison, so you could simply do: IF @@VERSION LIKE 'Microsoft...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: execution, serverproperty, SQL Server, TSQL, Version

1
kudos

Kudos

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

published 3 days, 4 hours, 44 minutes ago posted by

sa 12 days, 5 hours, 14 minutes ago

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

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, recently one of the databases were taking long time to finish the recovery whenever the SQL Server has been restarted and also during the RESTORE operations. Not an issue if this a Development environment but in the case of agreed downtime this...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: backups, Best Practices, CHECKDB, CHECKSUM, database consistency, dbcc, Restore, SQL Server, veirify only

1
kudos

Kudos

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

published 3 days, 4 hours, 44 minutes ago posted by

sa 12 days, 6 hours, 19 minutes ago

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

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 it as a must-attend event for DBAs, developers and BI professionals who work with SQL Server and similar to last event SQLBits 6 in South Wales the event will be running the three day format that was so successful . Day one will be a training day,...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, community, Conference, DBA, devloper, pre-con, SQL Server, SQLBits, Training

1
kudos

Kudos

SQL Server: What is the internal representation of all the datatypes?

published 5 days, 4 hours, 54 minutes ago posted by

sa 14 days, 5 hours, 24 minutes ago

SQL Server: What is the internal representation of all the datatypes?

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 must be compatible with the data types in SQL Server, also the data objects that are derived from source objects such as expressions are assigned to the base data type. Also BOL has enormous information to talk about it, a data type is an attribute...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: char, column, data types, format, integer, number, numeric, precision, Query, SQL Server, storage, varchar

1
kudos

Kudos

SQL Server Profiler: System is low on disk space on drive 'C'?

published 5 days, 4 hours, 54 minutes ago posted by

sa 14 days, 6 hours, 29 minutes ago

SQL Server Profiler: System is low on disk space on drive 'C'?

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 on a production environment, the impact of running this tool for longer time is high and it is also very important tool for DBA to see what exactly is happening on server side. This is where a server side trace is very handy perform a server-side...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, collection, ebook, free space, gui, low space, profiler, pssdiag, server side, SQL Server, trace

1
kudos

Kudos

Database Mirroring issues: Error: 1418: he server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

published 8 days, 5 hours, 9 minutes ago posted by

sa 16 days, 5 hours, 34 minutes ago

Database Mirroring issues: Error: 1418: he server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

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 future problems, though most of these are documented in Books Online and I see many times people raising them out on forums. You must use same version of SQL Server between the mirroring partners, including the witness server; Also the edition of...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Authentication, database mirroring, endpoint, error 1418, error log, kerberos, Monitoring, SPN, SQL Server

1
kudos

Kudos

Adhoc execution or schedule of a report - SQL Server Reporting Services

published 9 days, 5 hours, 14 minutes ago posted by

sa 16 days, 6 hours, 39 minutes ago

Adhoc execution or schedule of a report - SQL Server Reporting Services

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 to SQL Server memory area. Here is the brief reference from the documentation I would like to quote that SSRS service runs as single process & single account having the set of configuration files and most important one is RSreportServer.config...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: adhoc, report viewer, Reporting Services, schedule, scripting, SQL Server, sqlagent

1
kudos

Kudos

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

published 9 days, 5 hours, 14 minutes ago posted by

sa 18 days, 6 hours ago

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

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 changed in SQL Server 2008 R2. The high specificiation of physical resources you talk that refers to the highest edition of SQL Server which is Enterprise Edition and with R2 it is Data-Center edition. COming back to subject line I had to look at BOL...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: awe, Best Practices, cpu, edition, features, ia64, Memory, physical resource, SQL Server, Upgrade, x64

1
kudos

Kudos

TSQL to list of all foreign keys and their respective tables

published 9 days, 5 hours, 14 minutes ago posted by

sa 18 days, 7 hours, 5 minutes ago

TSQL to list of all foreign keys and their respective tables

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 and updates on a series of tables and want more accurate results and better performance. Obviously I have gone through the process within a test platform to ensure no issues for live data, and a quick requirement to disable foreign key constraints....(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: constraint, foreign key, information schema, SQL Server, TSQL

Welcome!

SQL Server

List of free resources and tools specific to SQL Server 2008 R2

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

SQL Bits 7 - Registrations now open

Backup of a FILESTREAM database may include garbage files as well

Stored procedure hangs, how to tell which statement is currently running?

List of KBA links updated specific to SQL Server 2008

Cumulative update package 9 for SQL Server 2008 Service Pack 1

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

SQL Server Management Data Warehouse 3 data collectors - useful facts

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

Execute a script based on SQL Server version?

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

SQL Server: What is the internal representation of all the datatypes?

SQL Server Profiler: System is low on disk space on drive 'C'?

Database Mirroring issues: Error: 1418: he server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Adhoc execution or schedule of a report - SQL Server Reporting Services

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

TSQL to list of all foreign keys and their respective tables

Open ID Login

Standard Login

Forgot Password?

Sign up