Viewing 15 posts - 41,341 through 41,355 (of 49,552 total)
Lynn Pettis (1/28/2009)
ARRRRGGGGGG!!!And the man keeps running even further into the desert.....
Why, oh why are you still helping him?
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
January 28, 2009 at 1:42 pm
Steve Jones - Editor (1/28/2009)[hr "whether its transaction log backups, and XML indexes or whizbang fiber-optic laser beam assemblers." that were copied word for word, and these aren't phrases you...
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
January 28, 2009 at 1:38 pm
Basically what happened there is that you had transactional replication set up (somehow), but the log reader wasn't running and never had run. Hence tran log entries that were marked...
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
January 28, 2009 at 1:36 pm
clperez271172 (1/28/2009)
from msdb..sysjobs sj
join msdb..sysjobsteps sjs on sj.job_id = sjs.job_id
join msdb..sysjobservers sjd on sjs.job_id =sjd.job_id
LEFT OUTER JOIN msdb..sysdtspackages dts on sjs.command LIKE '%'+cast(id as varchar(100))+'%'
where command like...
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
January 28, 2009 at 1:25 pm
One difference is in the reusability of the plans.
With ad-hoc sql, the text has to match precisely (including whitespace) before an existing plan will be reused. The following two generate...
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
January 28, 2009 at 1:20 pm
smeet.sinha (1/28/2009)
What are the underlying issues with the MS SQL architecture i dont know. But that would be...
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
January 28, 2009 at 1:13 pm
DBADave (1/28/2009)
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
January 28, 2009 at 1:03 pm
Smartdog (1/28/2009)
although ur solution may be working in this case, but it will not be working when passing 7 parameters as i want to do,
If you'd said in your...
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
January 28, 2009 at 7:59 am
kiman_keren (1/28/2009)
question number 3: i got this one
http://msdn.microsoft.com/en-us/library/ms190962.aspx
That link's got nothing to do with index algorithms. It's talking about how the execution plan shows a clustered index seek.
Try these two:
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
January 28, 2009 at 7:55 am
If the ALLSTAFF is not encrypted and the ALLSTAFF_dec is encrypted, then you need to be using the EncryptByKey function when you insert from AllStaff to AllStaff_Dec. You're trying to...
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
January 28, 2009 at 7:53 am
Well, you can tell your vendor friend that, far from the 28-32 GB that he says the proc cache is using, it's actually using only 4.6 and most of that...
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
January 28, 2009 at 7:48 am
nabajyoti.b (1/28/2009)
How do i find that it is in full recovery mode?How do i change the recovery model to simple or take a transaction log backup?
Is there a DBA there?...
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
January 28, 2009 at 7:44 am
Think you could maybe post the code that you're running? Without that I can't begin to guess why you're getting a syntax error.
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
January 28, 2009 at 7:39 am
Domagoj Orec (1/28/2009)
Ok, maybe not, but it is kinda weird.
Nah. Some people join to post on the forums (and hence gain points), many join just to read (and maybe submit)...
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
January 28, 2009 at 7:38 am
I would strongly suggest, if this is for a procedure, call sub-procedures instead of hving all the possible selects in the one procedure. There's a big parameter sniffing problem if...
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
January 28, 2009 at 7:35 am
Viewing 15 posts - 41,341 through 41,355 (of 49,552 total)