SqlServerKudos

All

1
kudos

Kudos

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

published 4 hours, 35 minutes ago posted by

sa 1 day, 5 hours, 35 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

Creating a unique constraint on a column that allows nulls

published 4 hours, 35 minutes ago posted by

sa 1 day, 6 hours, 40 minutes ago

Creating a unique constraint on a column that allows nulls

Primary keys, unique indexes and unique constraints all enforce uniqueness. The difference between the primary key and the unique index/constraint is that the primary key does not allow any NULL values. However whilst the unique index/constraints do allow...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: SQL Server 2005, SQL Server 2008, Tips and Tricks

1
kudos

Kudos

Don’t forget today is the last day for voting – SQLBits 7

published 4 hours, 35 minutes ago posted by

sa 1 day, 4 hours, 30 minutes ago

Don’t forget today is the last day for voting – SQLBits 7

Today is the last day for voting for SQLBits sessions. Make sure you get your votes in, go to the Public Sessions page to vote. Once the votes are in we will compile the agenda....(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

Backup of a FILESTREAM database may include garbage files as well

published 4 hours, 35 minutes ago posted by

sa 3 days, 3 hours, 31 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

App_name() function

published 4 hours, 35 minutes ago posted by

sa 3 days, 2 hours, 26 minutes ago

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

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

tags: app_name(), function, sql_server, T-sql, TSQL

1
kudos

Kudos

SQL Bits 7 - Registrations now open

published 4 hours, 35 minutes ago posted by

sa 3 days, 1 hour, 21 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

SQLBits7 Registration

published 4 hours, 35 minutes ago posted by

sa 3 days, 16 minutes ago

Registration is now open for SQLBits 7. If you want to attend Thursday or Friday AND Saturday then click the option for the relevant day and you can select you wish to attend the Saturday later on in the registration process. With the Saturday being a...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

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

published 4 hours, 35 minutes ago posted by

sa 2 days, 5 hours 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, 35 minutes ago posted by

sa 2 days, 6 hours, 5 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

Whats coming in SQL 11

published 4 hours, 35 minutes ago posted by

sa 3 days, 4 hours, 36 minutes ago

I keep hearing little bits about whats coming in SQL 11 and I’m getting really excited. I comment about how certain things don’t get fixed and so when I see things do get fixed it makes me smile. The latest is undo in SQL Server Integration services.My...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

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

published 4 hours, 35 minutes ago posted by

sa 3 days, 5 hours, 41 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

Want to support SQL Server ?

published 4 hours, 35 minutes ago posted by

sa 3 days, 6 hours, 46 minutes ago

Microsoft are recruiting SQL Server support people. https://careers.microsoft.com/JobDetails.aspx?ss=&pg=0&so=&rw=1&jid=21950&jlang=EN This job isn’t about understanding TSQL its about understanding programs, SQLServer.exe is a big...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Jobs

1
kudos

Kudos

Make yourself heard – How to change SQL

published 4 hours, 35 minutes ago posted by

sa 5 days, 6 hours, 56 minutes ago

We keep getting told that to get things changed with SQL Server we need to vote on connect items. I decided to look at the top voted items https://connect.microsoft.com/SQLServer/SearchResults.aspx?FeedbackType=1&Scope=0&SortOrder=15&TabView...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

CAST vs CONVERT

published 4 hours, 35 minutes ago posted by

sa 8 days, 5 hours, 45 minutes ago

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

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

tags: cast, convert, sql_server, T-sql, TSQL

1
kudos

Kudos

Report Builder 3.0

published 4 hours, 35 minutes ago posted by

sa 8 days, 5 hours, 55 minutes ago

Report Builder 3.0 has some minor additions that make your life a better world. On that i’ve just found is the ability to know what renderer is being used. Why is that useful? Well in all the training I do on Reporting Services I always highlight the...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Report Builder 3.0, reporting, Tips and Tricks

1
kudos

Kudos

Reporting Services – Custom Code requests

published 4 hours, 35 minutes ago posted by

sa 8 days, 7 hours, 5 minutes ago

Reporting Services – Custom Code requests

If you’ve been developing complex reports in reporting services then you will likely have resorted to custom code to solve issues like custom aggregations and custom colour palettes. Below are a set of suggestions that relate to developing custom code...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Connect, Custom Code, Report Builder 3.0, Reporting Services

1
kudos

Kudos

Changing a data source isn’t saved

published 4 hours, 35 minutes ago posted by

sa 8 days, 7 hours, 10 minutes ago

In report builder 2.0 if you change from a local to a shared data source or the other way round and click ok the change isn’t saved. This is clearly a bug in the forms IsDirty programming which detects if something has changed that requires saving. To...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

List of KBA links updated specific to SQL Server 2008

published 4 hours, 35 minutes ago posted by

sa 9 days, 2 hours, 55 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, 35 minutes ago posted by

sa 9 days, 4 hours 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, 35 minutes ago posted by

sa 9 days, 5 hours, 5 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

Welcome!

All

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

Creating a unique constraint on a column that allows nulls

Don’t forget today is the last day for voting – SQLBits 7

Backup of a FILESTREAM database may include garbage files as well

App_name() function

SQL Bits 7 - Registrations now open

SQLBits7 Registration

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!

Whats coming in SQL 11

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

Want to support SQL Server ?

Make yourself heard – How to change SQL

CAST vs CONVERT

Report Builder 3.0

Reporting Services – Custom Code requests

Changing a data source isn’t saved

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)

Open ID Login

Standard Login

Forgot Password?

Sign up