You can't use T-SQL in SSIS expressions you need to use the SSIS Expression Language. This blog post is a good place to start looking at this.

What jumps out to me in this plan is that there is an index seek followed by a key lookup. I'd be willing to bet that making the non-clustered...

Steve Jones - SSC Editor (12/10/2014)

---

Jack Corbett (12/10/2014)

---

So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of...

I'd say that I agree that there are people who are naturally better suited to being managers than others. I know I shouldn't be a manager. I think...

So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of the product are supported on what versions of Windows...

thisisfutile (12/10/2014)

---

I notice that each SQL Agent GUID ties out to an entry in the ReportServer database on the ReportSchedule table. Since I have dozens of scheduled jobs, all...

Steve Jones - SSC Editor (12/9/2014)

---

andrew gothard (12/9/2014)

---

App set up so exactly the same call is made a shedload of times? I've actually seen a 'database problem' where things...

Here's one way in pseudo-code to insert or update a row using the criteria you provided:

If @PinCount > 10 Then Raise Error

Else

If @PinCount + PinCount From table where frame...

It depends on the the needs of the business. Does the query need real-time access to the data on the linked server? For real time queries, I would...

tabubere (12/4/2014)

---

1.How can I write a code for a stored procedure to pass data to make changes to a player’s score in a frame of a game (input parameters user,...

Adam Machanic's sp_whoisactive returns it.

You can get it from sys.dm_exec_requests as well.

Ouch, I don't even think the crappy Java app...

simflex-897410 (12/3/2014)

---

Hi Jeff,

Yes, I did but since we don't have a support agreement with them, they are asked us what we tried and we told them the trigger I posted...

If you are using SSMS to get teh results and are using grid mode you can just copy and paste into Excel. You can also do File - Save...

Currently it is possible, but that functionality is deprecated. It also isn't a good idea as triggers are part of the transaction and returning data from the trigger will...