Viewing 15 posts - 241 through 255 (of 337 total)
Sorry.Didnt notice it.Seems like there is no fix for this.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144747&whichpage=2
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 31, 2011 at 7:07 am
You need to specify the logical name and not the physical name of the file.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 31, 2011 at 7:00 am
I am not to sure.
Set up the database in single user mode and then take backup and then set up to multi user.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 31, 2011 at 4:22 am
I always believed that maximum memory used for the cache will be 25% of the Non-Awe memory(if enabled).Also remember perform monitor wont give proper memory status if you have AWE...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 30, 2011 at 7:31 am
@Gail
Do you think table variables might also face "Allocation Page Contention" the way temp tables do ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 29, 2011 at 1:05 am
Just now I found this on MSDN
The lazy writer eliminates the need to perform frequent checkpoints in order to create available buffers.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 20, 2011 at 6:17 am
Checkpoint tries to write as many pages as fast as possible. Lazy writer tries to write as few as necessary.
Hey Gail thanks for the reply.
Now it is getting a bit...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 20, 2011 at 5:38 am
Ok I will do that and wait.:-) Hopefully someone comes up with an answer.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 5:55 am
No replies...:crying:
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 5:25 am
Just realised Soundex wont work if data is entered like this '9015 Canon' as soundex function does not works well on numeric identifiers
select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('9015 Canon'),SOUNDEX('Cannon')
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 3:04 am
Or else you can try the Soundex function.
select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('Cannon')
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 2:59 am
Sure... and sorry... I get a little touchy about people not following all the rules because of the huge amount of heat I've taken about it. Here's the link:
Sure.. no...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 17, 2011 at 9:42 pm
I realize the intentions are good here and thank you for that but there are a couple of problems with the code there. For one, it breaks several of the...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 17, 2011 at 2:07 am
GilaMonster (1/16/2011)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 16, 2011 at 11:46 am
GilaMonster (1/16/2011)
Because the amount of used space didn't chance, the amount of free space did. Hence the percentage of the file that was in use increased.
Yes now that makes sense.Thank...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 16, 2011 at 10:57 am
Viewing 15 posts - 241 through 255 (of 337 total)