Viewing 15 posts - 1,981 through 1,995 (of 8,760 total)
July 26, 2017 at 7:04 am
Forgot to ask, did you run DBCC CHECKDB ('DBNAME') WITH NO_INFOMSGS ALL_ERRORMSGS ?
😎
July 26, 2017 at 6:49 am
Have you tried the 64 bit version?
😎
July 26, 2017 at 5:34 am
Quick thought, looks like either that the update has removed the object with the id of 1106115727 by deleting from the system tables, have you reviewed the "upgrade" script?
July 26, 2017 at 5:12 am
July 26, 2017 at 4:56 am
July 25, 2017 at 9:13 am
Sometimes I wonder what people are doing with their years of experiencing developing SQL...
July 25, 2017 at 9:11 am
Try adding a covering index in the sort order to eliminate that expensive sort, almost half the cost. Also I would suggest reviewing the indices, when ever I see anything...
July 25, 2017 at 8:09 am
Name the servers from what I'm drinking at that moment with two digit iterative number at the end, LAARESXX for Lavazza Arabica Espresso XX, PEPOBOxx for Petrus Pomerol Bordeaux XX...
July 25, 2017 at 7:21 am
You can try something along these lines
😎
select
bdbm.TheMonth
,SUM(
CASE
WHEN DATEDIFF(MONTH,bdbm.TheMonth,GETDATE()) < 12 THEN bdbm.Sub1
ELSE 0...
July 24, 2017 at 9:16 am
Run Glenn Berry's SQL Server Diagnostic Information Queries
😎
July 24, 2017 at 3:25 am
Here is a quick suggestion
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#INPUT') IS NOT NULL DROP TABLE #INPUT;
CREATE TABLE #INPUT
(
July 24, 2017 at 1:32 am
Viewing 15 posts - 1,981 through 1,995 (of 8,760 total)