LOLOLOLOLOLOLOL!!!!

Umm...this script ran fine in 2005. Tested in master, AdventureWorks, and a...

K. Brian Kelley (2/28/2009)

---

If you already have an external scheduler, is there a reason to run it from within SQL Server? You could set up a batch job to call...

Greg Charles (2/27/2009)

---

First question is where is the package stored - in SQL Server or in the file system? If it's in SQL Server, you can take advantage of...

Chad Crawford (2/27/2009)

---

Gaby Abed (2/27/2009)

---

How many rows would this return? 🙂 (yes...it's different)

use AdventureWorks

go

declare @tableA TABLE(col1 int, col2 int)

go

--stmt 1

select name from tempdb.sys.tables where name like '%tableA%'

--stmt 2

select...

Try this...

How many rows would this return? 🙂 (yes...it's different)

use AdventureWorks

go

declare @tableA TABLE(col1 int, col2 int)

go

--stmt 1

select name from tempdb.sys.tables where name like '%tableA%'

--stmt 2

select name from tempdb.sys.columns where...

GilaMonster (2/26/2009)

---

1000 page is the usual rule-of-thumb. Smaller than that and the table will probably be in memory. Fragmentation is a disk issue, it doesn't affect pages in memory.

The other...

Steve Jones - Editor (2/25/2009)

---

Gaby,

I think this works to a point. When I worked at a small company, 3 or 4 instances, 5-10 databases, this is easy. When I worked...

It's not all that unusual it seems. There's a...

Jeff Moden (2/21/2009)

---

I absolutely agree... It's not what you can backup... it's what you can restore. I do at least one "practice" recovery a week and I'm not the...

venki (2/20/2009)

---

Hi,

I have a negative numbers in one of the column. Actually that is temperature min_temp.

Min_Temp float

In another table, the datatype is varchar for this data. I want to...

Thanks GSquared. I had a sneaky suspicision that was the case, but had to be sure in cases where the table is truly massive.

Thanks...

Definitely, feel free to update the script to do so. However, I've also submitted an updated script...