Viewing 15 posts - 1,111 through 1,125 (of 1,584 total)
Can anyone offer a solution to this issue regarding my post:: Yesterday @ 9:50 AM?
March 27, 2012 at 10:00 am
P Jones (3/27/2012)
March 27, 2012 at 8:31 am
UPDATE: I was able to find out why the COUNT was returning 20. Even though there is only one record in the example...because of the CROSS APPLY it is...
March 26, 2012 at 8:55 pm
Okay I'm trying out the tally table but am noticing some peculiar behavior (perhaps this is normal)
Consider this sample row of data:
tranidctrl-numbertc-numberpos-datetc-cardtrans-codeprod-codeprod-qtyMonthMonthNameYearSystem
1154842956|847632|431225|'2012-01-01 00:00:00.000'|'0012 '|31|'2;5;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0'|'9.287;11.51;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0'|1|'January'|2012|'PR'
When I use the functions originally attached...
March 26, 2012 at 7:45 pm
Try this script, it should work nicely - you can run it as-is replacing the "LinkedServer" name with a real linked server
IF OBJECT_ID ('tempdb.dbo.#DatabaseSizes') IS NOT NULL
BEGIN
DROP TABLE dbo.#DatabaseSizes
END
DECLARE @DB...
March 26, 2012 at 8:26 am
CELKO (3/25/2012)
March 26, 2012 at 7:48 am
Gail, thanks for the article, very informative and appreciated.
March 23, 2012 at 10:12 pm
So I was finally above to get a clean CHECKDB and have isolated the source of the problem: There are 3 replicated transactions/records that no longer exist at the subscriber...from...
March 23, 2012 at 2:24 pm
I've read that READ COMMITTED SNAPSHOT can put some serious bloat across tempdb as it needs to put everything in there temporarily while a query "does what it needs to...
March 23, 2012 at 12:09 pm
Thanks for the input! Regarding the restore....Due to resource restrictions I have all these databases in simple mode as they are pretty much only used for reporting. In the...
March 23, 2012 at 11:54 am
If it still appears hung, use processes explorer to kill the actual cmd session...
Are you using xp_cmdshell???
March 21, 2012 at 1:36 pm
In echoing others, change the sa pwd, Grant only CONNECT/SELECT/SHOWPLAN to the users
March 20, 2012 at 1:23 pm
This may be a silly point but if you're running this on a 32-bit windows server isn't the max RAM available only going to be 4GB?
March 19, 2012 at 1:10 pm
To aid what everyone else has already said (especially noting that some tables are only used monthly/yearly, etc), depending on how frequently you restart your MSSQL servers you can use/tweak...
March 18, 2012 at 11:54 am
Viewing 15 posts - 1,111 through 1,125 (of 1,584 total)