It sounds like you just need to re-work your grouping so that an entire work order is together. I'm assuming that you are using a tablix/table so you just...

Typically you want to give the better hardware to the database server. Web servers can be scaled out while database servers have to scale up.

If you have a foreign key defined on a column you cannot leave a value in the column that is not in the referenced table. Here are your options:

1....

If the server or SQL Agent is not running when the job is scheduled to run it will not run until the next scheduled time when the server/SQL Agent is...

I...

Wow, the thread has been quiet lately.

Had a great time at the PASS Summit last week where I got to see many threadizens. Ran into Rodders the...

SQL Guy 1 (11/13/2014)

---

zedtec (11/13/2014)

---

The interaction between application and database becomes slow all of a sudden.

I have run a trace but no slow queries found (all running under 5...

Truncating a table or deleting data from a table does not release space from to the operating system from the database file(s), if does make that space available for re-use...

You can find the last SQL Server restart using sys.dm_os_sys_info and the sqlserver_start_time column.

Before you DROP any indexes you need to:

1. Save the create scripts off somewhere.

2. Check...

So if there are no slow running queries what is the definition of slow performance?

Are you collecting any metrics to determine what might be...

zahid.nawaz (11/13/2014)

---

Here is the result of Fill Factor query.

schemaName, tablename, indexname, fillfactor

dbo Items ...

PearlJammer1 (11/13/2014)

---

What is the difference between the wide index already on the table, and if I where to alter the index by moving the fields from the key into 'included...

That's the actual creation of the index. I believe the percent_complete column in sys.dm_exec_requests is updated for CREATE INDEX so you can monitor it using that. I use...

You state that the pages are 80% full when you check fragmentation,...

Eirikur Eiriksson (11/12/2014)

---

Quick solution for educational and entertainment purposes (read "spanner in the works") using slight modification of Jack Corbett's data preparation.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_DATES') IS NOT NULL DROP...