I started using Visual Studio with DB Projects 6 years ago, once I got my head around using the project as my source of truth for code rather than the...

Yes, that's what I'm doing right now.  Your response...

I agree with you Steve, this has to be addressed. I would suggest Microsoft handle character data differently altogether and treat varchar as a string the same way C# or...

I agree with Steve about abolishing daylight savings; either leave it sprung forward or let it fall back and stay but either way I'm in favor of not moving the...

SQLExpress is free of licensing fees. If I am in a position that my server performance needs to exceed that of SQLExpress.... Yeah, the 8K is more than...

I too don't read this email from my mobile. The "crispness" I like. I like the editorial as the first item but miss the "In this issue" at...

Hi sfeldman,

I never found out what the resolution was because I left the company shortly after this post. At my departure we didn't attempt moving to the tempdb, it...

vlad-548036 (1/30/2013)

---

Thanks, that's what I initially had on my system. It is apparent now, that there is no way

declare @howmany int=3

insert top (@howMany)

can be used to...

the query plan cache is server scoped not database scoped.

you can filter for a specific database on dm_exec_sql_text.dbid by database id or use the db_name(dbid) to filter by database name.

b.dbid...

or to avoid the performance hit of the join...

I've seen this before. There is a negative...

Seems like you are finding yourself in a situation similar to one we encounter from time to time where I work. That is, you need to have a job...