Viewing 15 posts - 8,596 through 8,610 (of 49,552 total)
Please post table definitions, index definitions and execution plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 6:47 am
A balanced tree is always balanced, that's part of the definition of the data structure. It cannot be unbalanced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 6:46 am
Raghavendra Mudugal (6/27/2014)
(bit confused: how this value 268435456 is equal to 2TB? I mean through conversion)
First line in the answer:
The limit for us humans is 2TB, but SQL stores the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 5:30 am
GOODS (6/27/2014)
Hi Gail,One more question if I want multiple users to receive the email.how would I go about scripting it?
Straight from Books Online:
[ @recipients= ] 'recipients'
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 4:35 am
Select from sys.dm_exec_requests cross apply to sys.dm_exec_sql_text.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 4:33 am
DO: Test first. Hekaton is not an automatic silver bullet for performance problems. You may get no gain, you may get a reduction in performance. If you don't have good...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 4:32 am
Probably not. If the very small overhead of requesting locks is noticeable, you probably have other problems.
If you really want, mark the DB read only in its entirety, then SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 2:26 am
Eirikur Eiriksson (6/26/2014)
You must get up to date, crystal is out, Extrasensory perception network is in, still working on the reception though:alien::cool:
The problem with the ESP network is the signal:noise...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 2:20 am
The procedure does have parameters, because the error is referring to sp_send_dbmail. The bolded line is the problem
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SystemAlerts',
@from_address = 'DBAlerts@blake.co.za',
@recipients = 'Dlozi.Nzuke@interactivesa.co.za', 'nivashan.govender@interactivesa.co.za',
@query = 'exec SP, Sp_Compare_Acc_Comment'...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 2:19 am
There's really not enough information here. To evaluate hardware, I'd normally do a full week (or more) analysis on wait stats and perfmon counters (lots of them) at the least.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2014 at 2:11 am
Randy Rabin (6/26/2014)
Gail, your post got me laughing out loud (literally) this morning. My coworkers are all moving away from me now.
😀 And so it begins...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 1:24 pm
Plenty wrong. For starters, this
where cast(convert(varchar(10),PostingDate,110) as datetime) between cast(convert(varchar(10),@YearStartDate,110) as datetime) and cast(convert(varchar(10),@YearEndDate,110) as datetime)
Change that so that you have no functions of any form on the columns. Hint,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 11:47 am
SELECT UserID FROM UserColor GROUP BY UserID HAVING COUNT(*) = (SELECT COUNT(*) FROM Color);
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 10:52 am
Every backup to its own separate file.
Appending backups to the same file doesn't mean you can restore them all in one single operation, you'd still have to run the RESTORE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 8:00 am
Can you post that specific select into please? The entire statement.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2014 at 7:56 am
Viewing 15 posts - 8,596 through 8,610 (of 49,552 total)