Unless you have some form of auditing enabled, or traces running, that kind of info's not stored.

Wed-fri. Mon and tues are usually Pre-conference days.

The friday is sometimes slower than the other 2 days. I wouldn't say it's worth missing though.

One place I've used a time where I didn't want a date was in job monitoring. I have the latest time that a job may be completed before alerts get...

What were they?

Encrypted stored procs aren't hard to decrypt. Besides, if someone has the sa password, what stops them from conecting directly to the server and manipulating data?

Nothing, but that...

That's an idle conection. TRy runing sp_who2 while the slow query is executing, see what waits/blocks you have

You have lots of table scans. They ain't gonna be fast

@tmp_strategyid - A table variable? How many rows?

[MARKET_RISK_DB_US].[publish].[DIM_STRATEGY] - 3 table scans. How many rows?

[MARKET_RISK_DB_US].[publish].[DEAL_DTL] - 2 index seeks with...

jsheldon (5/15/2008)

---

Domain Admins never were a user to any databases (from our ERP down to Citrix) the blackberry server (4 dbs behind the scenes) had Domain Admin group as a...

Tell the boss it's an excellent learning opportunity. Tell him you will take details of all teh problems you're currently having and will sit with some MS developers and find...

Depends on the table. Heavy inserts tends to recommend a lower fill factor, while more static tables would probably have a higher fill factor.

It's far more important though to make...

Timothy Ford (5/15/2008)

---

First of all Grant and Gail, coming from the Program Committee, all I can say is that the sessions have been selected and it's to the point where...

Backing up he log doesn't change the size of the log file on disk. It just removes inactive log records (after backing them up) and clears space in the log...

Loner (5/14/2008)

---

I just had a SQL Injection attack last week. All the recommendations are good but the SQL statements are embedded in all the web pages in my company....

What does the print for the dynamic SQL return? Or does that also return an error?