Viewing 15 posts - 8,596 through 8,610 (of 49,571 total)
Please post table definitions, index definitions and execution plan.
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.
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...
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'
...
June 27, 2014 at 4:35 am
Select from sys.dm_exec_requests cross apply to sys.dm_exec_sql_text.
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...
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...
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...
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'...
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.
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...
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,...
June 26, 2014 at 11:47 am
SELECT UserID FROM UserColor GROUP BY UserID HAVING COUNT(*) = (SELECT COUNT(*) FROM Color);
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...
June 26, 2014 at 8:00 am
Can you post that specific select into please? The entire statement.
June 26, 2014 at 7:56 am
Viewing 15 posts - 8,596 through 8,610 (of 49,571 total)