For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it doesn't require a pre-existing tally table, which might be useful in...

You can try requesting the following from the DBA:

-- allow...

If you're organization is starting an IT automation initiative, then simply put: resistence is futile. When it does come time to downsize, then I guarantee you that those of you...

Perhaps what you need is a composite unique key, which would be the business code combined with something like a date/time column. For example, let's assume an Employee table is...

If you have a database with heavy write activity, something like a high volume DW or ETL staging, then placing the transaction log on a RAM drive would probably yield...

For this type of row filtering based on TOP(x) ranking, you can use the DENSE_RANK() function like so. You'll need to experiment with the PARTITION BY and ORDER BY clause...

There is no WHERE clause. This procedure will update all rows in the each column with the same value, which I'm sure this is not what you intend.

TheFault (5/10/2016)

---

There's often a...

onlo (5/10/2016)

---

Hello,

Unfortunately, we only use SQL Server 2014 Standard Edition, we can't use the memory optimized table feature.

Can I move just one table (it is a staging table) to a...

Haunch

Ed Wagner (5/6/2016)

---

I, unfortunately, completely get it. That's how I felt earlier this week. It's warming up here in Michigan and the heat was blasting. The furnace...

Cruise

ebooklub (5/6/2016)

---

Did you check how many job positions in (Internet of Things) and data analytics posted in you area?

I found that in my region (Montreal, Canada) jobs related "Internet...

jasona.work (5/5/2016)

---

Ray K (5/5/2016)

---

jasona.work (5/5/2016)

---

Now we just need to get our refi on our home completed with our credit union so we can see if the budget will carry this...

It would be hard to infer what would be the equivalent of referential constraints simply by looking at the code. I'd start all this effort by collaborating with a subject...