lonnyniederstadt (7/27/2016)

---

The allocation unit size has much less effect on size of SQL Server IO than is commonly believed.

Consider writes to the transaction log. Each write is a minimum of...

Indianrock (7/26/2016)

---

Yes I know it is for upgrading to a new version of sql server. Have you run the sql 2014 upgrade advisor successfully? My mention...

Indianrock (7/26/2016)

---

Apparently nobody uses this Microsoft Tool, and I can see why. I upgraded my local sql 2012 installation to SP3 and ran the tool against that. Got...

Just like anything else "it depends". In SQL 2012 there is no more CAL based licensing for Enterprise edition however if you have CAL licenses in 2008R2 you can transfer...

JarJar (7/4/2016)

---

i'm looking for some information about this error. i've read many articles on this and i'm still searching for a workaround.

checkdb has began to fail for one of...

babu.manoharan-1113385 (6/10/2013)

---

nice work, but couple of things wrong here being an SQL server guy you should not focus on Cloudera because Cloudera is blessed by ORACLE and Hortonworks is blessed...

Jeff Moden (6/23/2016)

---

curious_sqldba (6/22/2016)

---

Sean Lange (6/22/2016)

---

Do you know how...

Sean Lange (6/22/2016)

---

Do you know how to use a...

Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.

May be i didn't explain it correctly. Basically the curson will loop through list of databases and at the end the value in the variable @database should be A, B...

I will give that a try. I also wanted to know what is my page id in log record ID (1797221:955720:167).

davidlester.home (4/25/2016)

---

So I have an unusual performance tuning issue. We have a table, which has 185 million rows in it. There is a query we have that is grouping...

raf.figueroa (6/14/2016)

---

Hi curious_sqldba,

I am spreading the db, not for performance gain. Since the disks that I have are 5TB in size, then I will need x number of drives...

The first question i would like to know is why do you want to spread the db across multiple volumes? If you are thinking you would gain peformance that is...

KSQLDBA (5/31/2016)

---

What is "SQL Fertilization" any links?

its job description. I have googled it and i noticed that many jobs are asking: "Some experience with SQL fertilization helpful" I m trying...