For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk away disinterested. The same goes...

Samuel Vella (2/8/2012)

---

One thing I would love to be able to do in SQL is this:

(Simple example)

select

A,

...

jyoti.patel (2/20/2012)

---

We would like to automate a way to restart SQL at 5:30AM local time every morning. We have an application that hangs until the SQL service is restarted. Cau...

dbapt605 (2/17/2012)

---

Is it possible to insert a large number of records into a fairly big table, and not have SQL Server lock the entire table against updates or other smaller...

When it comes to implementing a parameter driven process that performs multiple steps and then returns a result, that should generally go in a stored procedure, not a function.

It is possible to...

Ray Herring (2/21/2012)

---

Eric M Russell (2/21/2012)

---

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not...

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not automatically members of Builtin/Administrators, But...

jeanyvesR (2/21/2012)

---

Many thanks Eric , I have added the credential in MSDB db_ssisoperator role and it works fine.

Before this try I have found this MS kb : http://support.microsoft.com/kb/912911/en-us and a...

jeanyvesR (2/20/2012)

---

Sorry :crying:, but I going to run the job and I got following error message :

Message

Executed as user: Domain\PROXY_USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0...

The 2nd example will work, if your change the factor from an interger to a floating point like so.

select (cast ('1' as smallmoney) * 1000000000.0);

Charmer (1/24/2012)

---

Hi Friends,

i have table which does not have any date time column, but my need is to get some records depending on the date&time...is it possible...

Revenant (2/17/2012)

---

If you watch TV commercials, you may notice that the best salesmen are cute kids, dogs, and cats, in this order. No experience necessary.

Draw your own conclusions, DBAs....

Steve Jones - SSC Editor (2/17/2012)

---

Jack Corbett (2/17/2012)

---

I think commissions for sales people is the best way to compensate them. You provide a lower guaranteed salary so...

RobertYoung (2/17/2012)

---

It appears to have gone away, but Spolsky did a great piece on pricing (and by example, sales staffing) of software. The title is "Camels and Rubber Duckies",...