Hehe. Try Lowell's suggestion, then.

Good luck!

jcrawf02 (6/9/2011)

---

Kiara (6/9/2011)

---

Grant Fritchey (6/9/2011)

---

Kiara (6/9/2011)

---

Tom.Thomson (6/9/2011)

---

Kit G (6/8/2011)

---

Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps......

Lowell (6/9/2011)

---

I'd always tackled this the other way...backup and restore to the dev database, then DELETE any data that doesn't match the saving criteria...works great if your FK's have the...

richardd (6/9/2011)

---

Nice article.

It makes me wonder why 64-bit SQL can't use 32-bit providers (eg Jet), since the bit-ness of out-of-process COM components doesn't matter. They'd only need a 32-bit...

If you just want them smaller, you can use this script.

Just make sure that foreign keys are resolved.

DECLARE @tableName sysname

DECLARE @schemaName sysname

DECLARE @sql nvarchar(max)

DECLARE tabs CURSOR STATIC LOCAL FORWARD_ONLY

FOR

SELECT name,...

ALZDBA (6/9/2011)

---

Are you in desperate need for coffee 😉

You provided the perfect answer for...

zaleeu (6/9/2011)

---

Okay , lets use this as an example.

MS SQL R2 Express 2008

Big live database has 10000 records. I want to use only a small portion of that for testing...

This should be enough:

INSERT INTO DatabaseB..DestinationTable

SELECT *

FROM DatabaseA..SourceTable

WHERE LastName = 'Smith'

You have many options.

Is it a one-shot export or you have to it regularly?

Both databases on the same instance or different instances?

Are the tables identical or you...

Rhox (6/9/2011)

---

Isn't it possible with the registered servers window?

- Create group and place all connections (per instances) in it

- Right click on the group and select 'New query'

- Execute your...

You can't do it with a SQL query, because each instance lives on its own and is not aware of othere instances on the same machine.

You could query the registry...

Not yet, really.

Is there a particular thread where he crossed the line or...

Johan,...

Our alphabet soup friend gives weird recommendations on LinkedIN

I'm starting to think he downloaded his certs from the pirate bay. 😀

rfr.ferrari (6/8/2011)

---

Sachin Nandanwar (6/6/2011)

---

Hi,

I am reading one book on SQL Server internals.When explaining the checkpoint process it states that

"....If the LSN of the dirty page is greater than the...