Have you checked if anything is blocking this query, or if you have an adequate index?

Wow, that's a lot of data (to be considered a sample).

I'll give it a try when I get home in the afternoon, because I want to do some tests that...

What's wrong with keeping it simple with a single SELECT statement?

DECLARE @NACELLE varchar(max) = 'NULL, NULL, NULL, NULL',

@timeint int = 5; --time...

Using CHARINDEX and SUBSTRING would be one option. To simplify it, you might want to use CROSS APPLY.

If You want more help, please post your data in a consumable format...

Just remember that if there's human input, there's a threat. It doesn't matter if it comes from outside or inside of the company. Protect yourself against any way that a...

Why is that a problem? Tables are designed to have...

As mentioned, you need to use dynamic SQL, but with your current code, you're wide open for SQL Injection. Here's an example on how could you do it.

CREATE PROCEDURE EP_Conterbalances

(

@Start_Date_For_Totals_Date...

If you only need the Ids, here's another option.

SELECT ID

FROM Test

WHERE Type = 'Non-IT'

EXCEPT

SELECT ID

FROM Test

WHERE Type = 'Manager'

The payment table looks almost as a fact table to me. Just remove the payment_id and invoice_id, and group by the other columns. You need to create a dimension for...

A little tough to answer before the morning coffee, but got it right.

It's a nice question, thanks.

You might want to review your code as it has some issues that might cause problems. Such as the use of sp_MSforeachdb (Check an alternative[/url]), functions on columns in WHERE...

I can't test right now, but instead of doing an insert an update in here:

INSERT @FinalResult (seq_num, database_name, iuser_name, principal_type_desc, role_name)

SELECT ROW_NUMBER() OVER(PARTITION BY database_name ORDER BY database_name ASC) AS...

Foreign keys can improve performance. It might not always happen, but there's a possibility.

http://www.scarydba.com/2010/11/22/do-foreign-key-constraints-help-performance/

Triggers can prevent deletes in general. This is good if you want that. If you only want...

Ed Wagner (7/20/2015)

Video Game...

Different fill factor? Difference on index fragmentation?