bsrlong (1/13/2009)

---

This is why I do not spend much time on fourms. Gee, and I signed up for this. People with answers such as this,

do not us...

On the original questions:

1. Use a variable if you'll need the value multiple times. Otherwise, don't bother.

2. Use a view if you'll use the exact same (or...

Check "select user" when logged in with your Windows account. If it comes back as something other than "dbo", then that might be the situation.

I read a story about a shop that kept point-in-time restore data for all applications on all servers, throughout their history. They could restore any retired server, into a...

Grant's solution will prevent that particular injection attack, but I'd watch out for more.

Another point on that specific one, is that someone could fairly easily end up with a full...

MSDN has tutorials for it. So do lots of other sites. Hit your prefered search engine, type in "sql server analysis services tutorial" and you'll have plenty come...

J (1/13/2009)

---

GSquared (1/9/2009)

---

I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something like...

I haven't generally had issues with MS hotfixes. The idea is "test them in your environment". SQL Server, specifically, is so environment-sensitive, that it's a tough beast to...

Okay. That makes sense then. Just not something I've thought of, and thus haven't used.

That error usually means that you are using Windows authentication, and the computers aren't passing the login data to each other. That's normal in a Windows domain, and there...

I do each backup to separate files. Name with DB name and datetime YYYYMMDDHHMM (hours and minutes matters with log backups). Single file = single point of failure...

I'm not sure there's an exact qualitative or quantitative answer to that one.

They recommend not applying CUs and hotfixes that you don't specifically need, and waiting for service packs instead,...

Stephanie J Brown (1/13/2009)

---

Allow...

I suggest building a calendar table, or at least a calendar view, to store such data. Lots of advantages to that.

get_sid is, as per the comment in the proc, only available within system procs.