Viewing 15 posts - 28,681 through 28,695 (of 49,552 total)
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Also, can you give some more detail as...
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 2, 2011 at 10:11 pm
Or are you missing a linked server that existed on the old server?
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 2, 2011 at 12:18 pm
SQLJocky (12/31/2010)
Just wondering if there are any issues backing up a DB from version 10.50.1746 and restoring to a previous version 10.50.1600?
That should be fine. That's restoring from...
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 1, 2011 at 1:42 am
Run a Profiler trace? If something is running against the server that can catch it. If not, then you've eliminated one possibility.
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
December 31, 2010 at 9:37 am
And please also post the query.
Please understand we're not asking for this information to make your life difficult. We're asking because it's very hard to give useful advice around performance...
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
December 31, 2010 at 9:30 am
SKYBVI (12/31/2010)
The whole purpose of deleting the unuseful rows was free up some space, which is not acheived..
You have freed up space. You've freed up space within the data file...
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
December 31, 2010 at 8:35 am
Typically to see if there are any rows you would use EXISTS.
IF EXISTS (SELECT 1 FROM <SomeTable>)
BEGIN
-- Some processing
END
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
December 31, 2010 at 8:33 am
See Books Online for syntax for this and just about any other command in SQL.
http://msdn.microsoft.com/en-us/library/ms189280%28v=SQL.100%29.aspx
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
December 31, 2010 at 8:06 am
Please note: 3 year old thread.
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
December 31, 2010 at 8:03 am
Your database is set to autoclose. That means as soon as the last connection to that DB closes, SQL cleanly shuts the database down. Each time the database is opened,...
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
December 31, 2010 at 8:03 am
It should still be on the front page. Published yesterday.
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
December 31, 2010 at 5:56 am
Cool. I'll write up a short checklist, will incorporate it into article when I rewrite.
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
December 31, 2010 at 2:49 am
zahrahLand (12/30/2010)
I do not work for Bookshop!!what is the problem with you guy? :crying:
You are making fun of me :angry:
No we're not.
We asked if this was homework (school project,...
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
December 31, 2010 at 2:44 am
You work for a bookshop?
Right idea with the not exists, minor missing detail. See: http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/ for specifics on EXISTS
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
December 30, 2010 at 4:27 pm
Craig Farrell (12/30/2010)
IT is the kind of cost that seems rediculously high and should be scaled back until you realize what you lost when something goes horribly wrong.
I've...
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
December 30, 2010 at 2:53 pm
Viewing 15 posts - 28,681 through 28,695 (of 49,552 total)