polo.csit (3/2/2015)

---

Hi All,

i am using the query

select id From Job where Title like '%java%'

it will take 10 sec time

after that i am using the Force Index Query Hints

like

select...

On the risk of sounding corny, welcome home Lynn!

😎

Cutting to the straight chase, cloud providers have no say about your M$ limitations or M$ contractual capacity, either you got this wrong or your question is wrong (maybe both?)

😎

Jeff Moden (3/1/2015)

---

Outstanding. Thank you VERY much for the time you've spent on this whether it may have been trivial or not, Eirikur. You obviously took some time...

Lynn Pettis (3/1/2015)

---

In Salt Lake City waiting for my last flight taking me home to Colorado Springs. I can't wait wait for this flight to already be in Colorado...

That would be the result set prior to the cross-tab or in other words, just remove the cross-tab case statements

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @table TABLE

(

...

evaduva (2/28/2015)

---

Hi,

Could someone please tell me what is the maximum size of a DB hosted on SQL 2012 cloud environment? I would appreciate if the answer came from a real...

Importing a spreadsheet like this in SSIS would neither be considered trivial nor complex, more in the category of multi document files, on the scale of 1-100 it could be...

TomThomson (3/1/2015)

---

Nakul Vachhrajani (2/27/2015)

---

Easy one.

What's interesting is that 32767 is the upper limit for SMALLINT (2-byte/16-bit integers). Yet, the database identifier has a data-type of INT, not SMALLINT. I...

SwePeso (3/1/2015)

---

Be very careful with LAG here. If you for some reason don't have data for the previous measure period, you will get the measure period before that.

That's why why...

Have a look at this article by Paul White

😎

Jeff Moden (2/28/2015)

---

Eirikur Eiriksson (2/28/2015)

---

Jeff Moden (2/27/2015)

---

Zero bottles of beer on the wall.

Zero bottles of beer!

For those that roam,

Just come on...

Quick question, is this on a cluster? Can you tell us how you have done it?

😎

Double checked it doesn't exist on either of the nodes?

😎

How is it going? Done yet?:-D

😎