I create a dev environment that parallels the production environment, in terms of disk names, windows domains, etc. Then develop on there.

I usually deploy the packages to msdb instead...

Terrie (1/7/2013)

---

I'm just trying to make sure I understand. So shrink with notrucate moves the pages to the front of the file and does not release the space to...

That's the way to do it!

I make it really easy on myself and keep a Calendar table in a database called Common, on each server.

The table has each day as a row. Columns include...

The fact that their own FAQ on using their product to back up SQL Server databases has incorrect information in it isn't promising to me:

If you use SQL's own backup...

It depends on the size of the indexes. They have to have enough room to be rebuilt. How big are they?

Rebuilding in tempdb won't necessarily help with overall...

Move pages to the beginning of the file. Mildly...

It depends on the business-definition. Which is usually the ISO definition, but not always.

Most places I've worked, they want the first week to include 1 Jan, but to start...

Try this:

DECLARE @Date DATE = GETDATE();

SELECT *

FROM Client_Trades.DBO.Trades

WHERE Trade_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, @Date), 0)

AND Trade_Date < DATEADD(MONTH, DATEDIFF(MONTH, 0, @Date)+1, 0);

What that does is calculate the first day of...

In that kind of situation, yeah, shrink the database, and rebuild the indexes. See if you have the option to rebuild them in tempdb, since that can help reduce...

The encryption piece doesn't even matter. What obviously happened is Vader left his laptop where a rebel could steal it. Probably lost it on the bus on...

dwain.c (1/6/2013)

---

GilaMonster (1/6/2013)

---

Stefan Krzywicki (1/6/2013)

---

GilaMonster (1/6/2013)

---

Stefan Krzywicki (1/5/2013)

---

In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not...

dwain.c (1/3/2013)

---

About a week and a half ago, I bought my wife...

sqlpadawan_1 (1/7/2013)

---

With a terabyte of storage for less than $100, free utilities like Sync Toys from Microsoft, and unlimited online backup services as cheap as $60\yr, I will never understand...

Concatenate the list of columns into a string, use that in dynamic SQL. It's the only way to to do what you're trying.