Viewing 15 posts - 38,581 through 38,595 (of 49,571 total)
Tom Brown (6/9/2009)
I may be totally wrong or this could be too simplistic, but thats what I understood from the Wiki article and various other researching.
That's pretty much...
June 9, 2009 at 7:27 am
Please post the query, table definitions, index definitions, function definitions and the execution plan (saved as a .sqlplan file, zipped and attached)
June 9, 2009 at 5:28 am
Look up BACKUP DATABASE and RESTORE DATABASE in Books Online (the SQL help file). There's a good amount of info there.
Backups are online operations, nothing to worry about if...
June 9, 2009 at 5:27 am
There is. Calculated persisted columns can be indexed. Full details in Books Online.
June 9, 2009 at 5:14 am
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...
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...
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...
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...
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...
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...
June 9, 2009 at 3:48 am
One cached execution plan that will be reused for all calls to the procedure.
June 9, 2009 at 3:35 am
Ol'SureHand (6/8/2009)
Not sure if to create a new topic ...
Please do.
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.
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)
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...
June 9, 2009 at 3:27 am
Viewing 15 posts - 38,581 through 38,595 (of 49,571 total)