SSAS, Hadoop and...

Ray K (10/14/2016)

---

Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and went...

incited

Luis Cazares (10/14/2016)

---

Here's a simple option using the DelimitedSplit8k that can be found here along with its explanation: http://www.sqlservercentral.com/articles/Tally+Table/72993/

A specific function could be made to split only on the 7th...

Jeff Moden (10/6/2016)

---

Alan.B (10/6/2016)

---

No need to use the Query method, it would be more efficient to just use value like this:

SELECT Id ,

...

No. The temp table is just so you...

Mostly one Filegroup has one Data File.

Log file is on L:\ drive

But one huge 563 GB data file 'Scene_Data2' also lives in L:\ drive.

Probably interfering with Log file.. or it...

This is pretty simple. You would just add a <None> option to your parameter drop-down; have a look at this:

-- table that provides the parameter options

DECLARE @yourtable TABLE (val...

Good. You a Cubs fan now. Go Cubs!

No need to use the Query method, it would be more efficient to just use value like this:

SELECT Id ,

XmlCol.value('(text())[1]',...

Great, great work Drew. Very well done.

ramyours2003 (10/4/2016)

---

HI

I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for performance. We...

amy26 (10/5/2016)

---

But the report viewer is only available "intranet" its not available on the internet... our website is public facing. The database server is not accessible from the outside....

Part of the SSRS setup is configuring a Report Server URL. This is something you can also do after SSRS is set up. The Report Server URL is where you...