I would not do that unless you have a good reason and understand the tradeoffs; it's not going to...

Zapper (6/22/2011)

---

Hello,

I was also told that if the DBs were moved back to local disk, we would see a huge decrease in performance, which I'm also not buying.

Any comments...

Ask the SAN guys to map the LUNS down to individual spindles; and for...

Get SQL Server Express with Advanced Services; practice SQL admin tasks. Back up, restore, apply service patches, do index maintenance. Build stored procedures to do those things. ...

Puneet Malhotra-314029 (6/23/2011)

---

you can recover the hash and if there's a software which can translate that hash into the password(Reverse Hashing), then it may be possible. But I haven't come...

No; not at all impossible. How fast you can do so depends on:

A) Whether you can...

If it was a poor or a short password, you can brute force or dictionary attack it.

Otherwise, Elcomsoft has software to adjust the Master database directly and replace it with...

Charles Kincaid (6/20/2011)

---

In a design meeting when the organizer asks if there is anything not covered in the specifications, raise your hand an utter the three deadly words....

Agreed, Microsoft patching is nowhere close to what a true 24x7 mission critical OS should be. Requiring reboots is ridiculous (Novell Netware didn't, even for kernel patches, much less...

To be able use bcp to generate text files from within SQL code/stored procedure, such as for reporting (or even logging).

Also, to execute administrative batch files such as drive maintenance...

Raghavender (6/11/2011)

---

Hi All,

I came to know that PostGreSQL is a RDBMS. can any one of you came accross of this technology ? how will be the future if we work...

As an option if you're going to work with a LIKE in the first place,

LIKE [0-1][0-9][/-][0-3][0-9]

and so on and...

May I suggest as an optimization fewer but more complex UPDATE statements, to reduce the amount of I/O?

As a very rough example, the first two statement could collapse to:

Update dbo.Table1

Set...

Personally, I'd say you should always check important calculations in some "by hand" way; just because you think you programmed the software right, doesn't mean the results come out.

Special rounding...

1) Index usage DMV's are emptied when SQL Server is restarted http://msdn.microsoft.com/en-us/library/ms188755.aspx

2) When properly, precisely done checksums (all columns fixed width or very, very careful delimiting (CHAR(31), perhaps), COALESCE/ISNULLed to...