Viewing 15 posts - 30,436 through 30,450 (of 49,552 total)
Bodhi Densmore (9/22/2010)
I suspected that it is a "gap in functionality" but my query does not fit,
"[font="Times New Roman"]If the predicate of the query and the index...
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
September 22, 2010 at 1:20 pm
This perhaps?
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=454744
Try adding the CBIVisitNumber column as an include column. From what I recall when I investigated this, it's a usable workaround.
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
September 22, 2010 at 1:06 pm
😀
It's been a long time since I've written verse though (and I can't claim any of that was particularly 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
September 22, 2010 at 12:51 pm
Alvin Ramard (9/22/2010)
There was no attempt at any form of poetry.Records are read,
Logs are backed up.
Some poems rhymes,
And some are messed up!
😛
I am seriously contemplating submitting a PASS...
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
September 22, 2010 at 12:40 pm
iqtedar (9/22/2010)
Thanks Gail. Lets say if i run the trace for 30-60 mins in one day, but then how would i be able to capture the queries after 60 mins?
In...
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
September 22, 2010 at 10:19 am
Offhand, not sure.
If you think it might be transactional replication with queued updates, then repeat the procedure, but select a transactional publication with queued updates and see if, by deleting...
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
September 22, 2010 at 10:18 am
Maxim Picard (9/22/2010)
Gail: can you explain what you mean I am probably missing something here and don't want to be giving this fellow bad advice !
Sure...
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
You will I hope forgive...
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
September 22, 2010 at 9:21 am
Steve Jones - Editor (9/22/2010)
zenchew (9/21/2010)
I think braindumps are the best way to preparation.Braindumps are not the best way to prepare. They a shortcut and they don't teach you.
Plus...
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
September 22, 2010 at 9:20 am
Developer edition is feature-equivalent to Enterprise edition at a fraction of the cost and with a non-production license.
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
September 22, 2010 at 8:03 am
Regular checkDB checks are about the easiest - restore a backup to a secondary server, checkDB that. That way you test out your backup and you do an integrity check...
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
September 22, 2010 at 7:55 am
Enterprise edition on a dev server? That's going to really hurt the licensing budget. (Enterprise has to be licensed (;processor or CAL) regardless of how it is used)
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
September 22, 2010 at 6:59 am
The Dixie Flatline (9/22/2010)
One other variation:;with cte as (SELECT TOP 10 * FROM Stock.Register ORDER BY Stock.Register.id)
SELECT *
FROM cte
INNER JOIN Stock.Status ON cte.stock_status_id = Stock.Status.id
Careful with that. With 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
September 22, 2010 at 6:55 am
Jan Van der Eecken (9/22/2010)
GilaMonster (9/22/2010)
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
September 22, 2010 at 6:11 am
Grant Fritchey (9/22/2010)
GilaMonster (9/22/2010)
Ran across this earlier, thought it appropriate.Ha! I have that hanging at my desk.
I have this one hanging above mine (at home)
http://www.despair.com/despair.html
I bought this one for my...
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
September 22, 2010 at 6:03 am
Then you probably want to either use bcp or write an SSIS package. That's beyond the capabilities if the import/export wizard (though you can use that to create one package...
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
September 22, 2010 at 4:21 am
Viewing 15 posts - 30,436 through 30,450 (of 49,552 total)