Viewing 15 posts - 38,566 through 38,580 (of 49,552 total)
karthikeyan (6/9/2009)
Big O notation means the steps to complete a problem. Right?
No. Not at all.
Big O notation describes the time complexity of an algorithm. That is describes how 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
June 9, 2009 at 4:24 am
sp_attach_single_file_db should rebuild the log, not go looking for it.
exec sp_attach_single_file_db @dbname = 'MyDB', @physname= '< Full path to file > file1_a.mdf'
If that doesn't work, I don't think you'll 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
June 9, 2009 at 4:13 am
pkuchaliya (6/9/2009)
But i have not recieved the answer from anywhere , so i posted
You posted the question in two different forums 1 minute apart. There's no way someone will...
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
June 9, 2009 at 4:10 am
BrainDonor (6/9/2009)
If a selection is required on the date part of a datetime field what would be the best way of doing it?
BETWEEN's often very useful
Another method I have 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
June 9, 2009 at 3:54 am
Cross posting is posting the same question in two or more forums. Please don't do it. It's not necessary, many people read all the forums. Also it just leads 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
June 9, 2009 at 3:52 am
Firstly look up CONVERT in SQL's Books Online. Check the format codes, see which one will give you the date in the format that you want.
Then, add the convert function...
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
June 9, 2009 at 3:48 am
One cached execution plan that will be reused for all calls to the procedure.
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
June 9, 2009 at 3:35 am
Ol'SureHand (6/8/2009)
Not sure if to create a new topic ...
Please do.
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
June 9, 2009 at 3:35 am
Any form of function on a column will prevent index seeks on that column. So if you use that form in a where/join, you may very well be hindering 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
June 9, 2009 at 3:32 am
After taking the max, cast it to a string of length 10. Use CONVERT and make sure you get the right format code. (See Books online)
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
June 9, 2009 at 3:29 am
If someone I was considering noted that they posted on forum X, you can bet that I would check it out to see what they are posting. I've never googled...
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
June 9, 2009 at 3:27 am
usman.tanveer (6/8/2009)
but i am getting an error in the second step, when i tried to restore the most recent differential backup i got following error.
That error comes from restoring a...
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
June 9, 2009 at 2:56 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic731203-146-1.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
June 9, 2009 at 2:51 am
Did attach_single_file_db work?
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
June 9, 2009 at 2:36 am
San (6/8/2009)
How can we utilise FIRE_TRIGGERS option.?
Fire triggers is a property of the BULK INSERT command and it controls whether or not insert triggers are fired for a bulk insert...
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
June 9, 2009 at 2:34 am
Viewing 15 posts - 38,566 through 38,580 (of 49,552 total)