Grant Fritchey (3/12/2015)

---

The best place to go for this type of information is Denny Cherry. Here's his book. He also as lessons on Pluralsight. The new version of the book...

miamikk204 (3/8/2015)

---

I had to to relocate the database log file and I issued an Alter database command but by mistake I put a space in the file name as below....

You sure about putting all your users into database reader role? What That means is every user will have read permissions over each table, unless you explicitly deny. It does...

Visit his site: https://ola.hallengren.com/sql-server-backup.html

Install...

Do you run any job to refresh stats every week? How often do you defrag your Indexes?

If for some reason the answer is no for any of those, I think...

Eric M Russell (3/5/2015)

---

It may be a bug related to maintaining ACIDity in high transaction volume applications, and identity / sequence incrementation is just the most noticable side effect, because...

sqlcentral.dah328 (3/5/2015)

---

sql-lover (3/5/2015)

---

sqlcentral.dah328 (3/4/2015)

---

I ran into this same problem with SQL Server 2012 and this was one of the few places where anyone took seriously the possibility that the identity...

sqlcentral.dah328 (3/4/2015)

---

I ran into this same problem with SQL Server 2012 and this was one of the few places where anyone took seriously the possibility that the identity seed was...

mp5387 (3/4/2015)

---

Hi Sql-Lover,

Thanks for your answer. Do you mean after restoring my database from SQL 2008 on SQL 2012, I should change compatibility level on server 2012 to "120"...

Yes

You can restore from a lower version to a higher version. You cannot restore from higher version to lower.

You may have to change database compatibility level after the restore so...

ZZartin (3/4/2015)

---

While I totally understand the value of knowing what's going on behind the scenes why anyone willingly subjects themselves to a command line interface unless given absolutely no other...

JeeTee (3/4/2015)

---

Hi All,

This is NOT a question about when to or not to use loops and cursors, but I have heard from several places that using cursors seems "more intuitive"....

Kevin Stride (3/4/2015)

---

Is the best config to set the min and max memory with Hyper-V and then set a slightly lower upper limit within SQL Server? Ie

Hyper-V

Startup mem - 4096mb

min...

podmate (3/4/2015)My bias is showing as I come from the Unix/Linux world and have trouble with the very limited options (mostly pointy/clicky stuff) available in the MS world. Again,...

S_Kumar_S (3/4/2015)

---

Hi All

I have an application server APP1 in Domain DOMCORP. Then there is another SQL Server machine in DOMCORP domain. The SQL Service is running with Local system account.

When...