Viewing 15 posts - 706 through 720 (of 1,838 total)
October 17, 2017 at 10:27 am
Too many joins can make a query perform poorly and it can help to break down an extremely large query, especially if some of them are filtering logic joins and...
October 16, 2017 at 10:55 am
It's difficult to tell from this small a sample of data, but here's a couple of options, depending on how many rows per GROUPID you have in your history table...
October 12, 2017 at 1:28 pm
The 2 are not necessarily correlated. You can get a quick summary of file latency and a view of how much log space is used like this:SELECT...
October 12, 2017 at 11:02 am
I'd say my favorite would have banana peppers, sausage, and black olives on it. I'm not much a fan of Pizza Hut's crust though, there's some local chains I prefer...
October 11, 2017 at 3:19 pm
SELECT *
FROM dbo.blah
WHERE PID = 1
They both perform...
October 11, 2017 at 3:13 pm
Have you looked at the execution plan of the stored proc to see if the index is actually used?
Also, what other queries are executed against this table UO_MList? If...
October 11, 2017 at 11:03 am
It's actually a 20% threshold for autoupdate of stats, although there's a trace flag that can somewhat improve that behavior. Here's an article that has many subtopics about database statistics:
October 11, 2017 at 10:14 am
Lynn Pettis - Tuesday, October 10, 2017 10:48 AMChris, decided to play with your code a bit:
cool, I didn't know IntegerData...
October 10, 2017 at 11:39 am
October 10, 2017 at 10:12 am
you can get some information about growths by looking at the default trace:--history
DECLARE @path NVARCHAR(260);
SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'
...
October 9, 2017 at 2:11 pm
the other easy option that comes to mind then is a SQL Server Agent job that has a step of type:
Operating System (CmdExec)
October 9, 2017 at 1:40 pm
October 4, 2017 at 6:58 am
October 3, 2017 at 10:03 am
October 3, 2017 at 9:20 am
Viewing 15 posts - 706 through 720 (of 1,838 total)