Query scoped named sets may be what you are after:

http://msdn.microsoft.com/en-us/library/ms145487.aspx

Chris Houghton (5/27/2011)

---

khullargirish02 (5/27/2011)

---

The answers are different for each line.

In prefix compression, does the entire prefix stored in the header need to match the data to be used?

No

if I have...

gsc_dba (5/26/2011)

---

ryan.macy (5/25/2011)

---

We have all of our data files on D:\ and our log files L:\.

I have to attach around 1k worth of databases and I was curious if anyone...

ryan.macy (5/25/2011)

---

We have all of our data files on D:\ and our log files L:\.

I have to attach around 1k worth of databases and I was curious if anyone had...

This link may help you... http://technet.microsoft.com/en-us/library/ms188712.aspx

The wizard will immediately inform you of any pitfalls in 2008 R2

You may want to find out what and why they are taking so long but try: http://www.sqlservercentral.com/Forums/Topic193509-5-1.aspx#bm193857

Also works in a Sharepoint integrated setup.

🙂

[]Use <!-- to comment out the parts you dont want (as opposed to deleting...

Try this :

http://mysqlserverblog.com/2008/01/03/changing-export-options-for-reporting-services.aspx

Change the directories to suit a 2008/R2 setup

Ouch!

Thats very patient! :w00t:

Did you login/register when prompted?

http://technet.microsoft.com/evalcenter/ee315247.aspx

I logged in with my live account (as prompted), waited for 7 or 8 minutes and could download the iso image

I was also able to use this link, again with...

Did you use:

http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx

Which browser (and version) are you using...I use Chrome and the download above works fine for me.

murray50 (7/15/2008)

---

I have over 600 stored procedures that do not have nocount set on and I have been asked to do performance tuning on them to include setting nocount on....

Our company have used this in the past:

http://www.datamasker.com/

Consider this too:

http://www.grid-tools.com/products/fast_data_masking/data_masking_SQL_server.php

How about using your existing method but using a schema (in your example "staging")

SELECT [sys].[objects].[name]

FROM sys.objects

INNER JOIN sys.[schemas]...

Very useful - thanks for sharing!

"Clean" version of code:

USE [DatabaseNameGoesHere]

;

WITH cteFk

AS ( SELECT a.parent_object_id AS...