Viewing 15 posts - 1 through 15 (of 57 total)
with those words it gives the feeling you have doubts so i found some more info:
https://msdn.microsoft.com/en-us/library/ms181714(v=sql.90).aspx
RECOMPILE
Instructs the SQL Server 2005 Database Engine to discard the plan generated for...
April 16, 2015 at 3:15 pm
over a year ago i had similar issues with sql 2005 and cognos.
although updating statistics helped a bit the problem wasn't fully solved.
it is very tempting to think "oh i...
April 16, 2015 at 9:08 am
(besides the "where does it come from question")
January 13, 2015 at 3:45 pm
is it an option to shutdown sql server and start again ? sql rebuilds the tempdb when it starts again.
there are some options to decide which size you want to...
January 13, 2015 at 3:44 pm
it was funny to read. even if it was originally 2004. not so funny if your in it your self i know.
i thought our supplier who wanted to make a...
February 9, 2012 at 8:09 am
Aaron N. Cutshall (9/12/2011)
September 13, 2011 at 6:51 am
The remarks about increased cost for somebody and the response about "based on groups" and genes excluding you from it ... made me wonder about "ethical hackers". (imagination) People who...
September 13, 2011 at 6:33 am
i'd like to confirm GilaMonster. I have seen several situations where a rollback couldn't get out of the rollback.
A risk you run is that the rollback still needs to...
August 3, 2011 at 2:37 am
Answer 1: find the cause of the problem. Then think of solutions. Specific solutions cant be given as there are too many things that can go wrong to answer your...
August 3, 2011 at 2:28 am
removed original text, couldn't delete post.
July 11, 2011 at 3:18 am
what about restoring the model backup on a different server with a different name ? make sure the mdf / ldf file stay the same (just a different folder). you...
July 11, 2011 at 3:07 am
did you check if a disk/tape backup product is using volume shadow copy to backup your databases while online ?
often this is called "backup open files" in backup software....
June 21, 2011 at 9:06 am
windows account locking
February 28, 2011 at 4:34 am
i had problems with sql 2005 installation and the cause for me was missing files. the person who distributed the setupfiles didn't notice he forgot a large chunk of files.
point...
April 19, 2010 at 3:23 am
perhaps a short explanation how the log file internally work solves your question. i left out some technical details though.
the log file is a chain of virtual log files. you...
April 13, 2010 at 9:00 am
Viewing 15 posts - 1 through 15 (of 57 total)