Note that nothing I nor anyone else said means that you don't ALSO have suboptimal indexing on your system. In fact I can say that I have NEVER, in 20...

1) we have no sample tables and data and expected output to help you with the code.

2) you have multiple cursors (not even declared fast_forward). Row-based processing in SQL Server...

Tac11 (8/24/2016)

---

Hi Gurus,

I have found that a database is taking more than 50% buffer pool memory and I even located that 4 clustered index taking top buffer pool memory around...

Grant Fritchey (8/24/2016)

---

It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically...

I don't think it is still "required" but it used to be that upgrading versions mandated full-scan statistics updates on all statistics in every database migrated.

1) if your job puts data into a table I don't see why you need to wait for a SUBSEQUENT RUN for that data to show up on a dashboard....

DuncEduardo (8/23/2016)

---

I wouldn't say it's completely a "running total" problem as you require only previous 12 records from the one in scope.

Running Total will keep adding next value but not...

Grant hit the nail on the head. I have a ONE ROW, ONE COLUMN demo (on AdventureWorks no less!!) that shows a poor query plan choice from a table variable...

This is a simple running totals problem. If you search these words you will get relevant hits: running total sql server itzik

Please provide sample table scripts and sample data (scripted as INSERTs in to your tables) along with expected output so we can better help you.

I will note that you are...

weekend_79 (8/20/2016)

---

Hi

SQL Server 2012

db server receives insert/update calls from multiple application servers at exactly same time.

Sp took 1 sec to complete one call, so multiple executions of same sp...

Sorry, but I don't understand your requirement at all.

Please provide a COMPLETE set of data (scripted like you have) and a COMPLETE set of output(s) that you want from said...

http://stackoverflow.com/questions/16193152/sql-server-convert-select-a-column-and-convert-it-to-a-string

http://stackoverflow.com/questions/7755815/merge-row-values-into-a-csv-a-k-a-group-concat-for-sql-server

http://blog.sqlauthority.com/2008/06/04/sql-server-create-a-comma-delimited-list-using-select-clause-from-table-column/

sys.tables has this information:

https://msdn.microsoft.com/en-us/library/ms187406.aspx

crazy_new (8/16/2016)

---

Hi Guys,

I have a quick question about non clustered indexes. If I have an index across 4 columns and I have a query that only filters using one of...