titsiros (1/13/2016)

---

I have access and relatively good knowledge of both databases. Unfortunately this is not simply a task of appending the data as the system allows users to maintain lookups,...

michael.welcome (1/11/2016)

---

If you want and even more difficult task, try explaining to management types why this is not simple and easy thing to do.

Adding a fixed amount to identity keys...

Eirikur Eiriksson (11/6/2015)

---

On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

Three options given

1) To get the current time (wrong)

2) You don't (correct)

3) Time for...

xsevensinzx (11/5/2015)

---

Brandie Tarvin (11/5/2015)

---

BWFC (11/5/2015)

---

Woolly nebulous request of the month alert.

I've been asked to look into ad-hoc reporting solutions so users can create their own reports.

All I know is it's...

Check out this article

Jeff Moden (11/2/2015)

---

Yeah but he's 6 inches...

Jeff Moden (10/22/2015)

---

I could be missing something on that link but it would appear that you've once again written an...

Jeff Moden (10/21/2015)

---

Jayanth_Kurup (10/20/2015)

---

with 100 million rows your better off using a Columnstore index or moving the table to SSAS. If the report requires data on a monthly basis partitioning...

Sergiy (10/20/2015)

---

Kristen-173977 (10/20/2015)

---

I would only re-create a clustered index if there isn't one already - any existing...

gingerdazza (10/13/2015)

---

It's all very well agreeing SLAs for SQL services in terms of nines, but how do you ever translate any SLA (i.e. 99.9% or 99.99%) into 'which SQL architecture...

Part of the SLA is your best guess at downtime and the hardware, processes, and people you will need to support different levels.

The business determines how much they are willing...

Creating a 4/4/5 fiscal calendar, 52 weeks in every year, same number of weeks in every month, with first and last weeks holding the extra days, might make most comparisons...

NOT EXISTS, from what I understand, is a simple Boolean check.

Aggregates must first gather all results.

I am not at all surprised it is generally faster.

Many times I found it to...

Brandie Tarvin (10/1/2015)

---

BrainDonor (10/1/2015)

---

I've been to Canada more times than I can recall - maple with pretty much...

Steve Jones - SSC Editor (9/28/2015)

---

xsevensinzx (9/28/2015)

---

I can understand the what the author means in the article, especially in the BI realm on my end. Sometimes there is just not...