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...

Jpotucek (12/3/2014)

---

Select * from Sys.traces only shows the default trace : (

1 1 F:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\log_201.trc ...

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

---

Don't knock LinkedIn too much. It's networking, which is incredibly valuable if you need employment or want to move. Many of you have used networking...