Viewing 15 posts - 1,291 through 1,305 (of 2,462 total)
GilaMonster (9/21/2010)
Bhuvnesh, sure there wasn't an index rebuild job running around the same time? Index rebuild will grow the DB
Thats correct, you hit the nail at right spot. actually...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 11:43 pm
This chain of reply/comments is really informative and helpful..i seriously took printout of everything and had a thorough look while heading back to home in my office cab.
@steve-2...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 11:09 pm
abcim (9/21/2010)
How to widen index?
as gail suggested in her prior post
2) Widen the index [dbo].[SubCategoryNAICSCode].[IX_NAICSCode], add SubCategoryID as an include column
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 5:27 am
Andrew Gothard-467944 (9/21/2010)
Has this database been set up using default sizing?
this DB belongs to our new clients.So cant comment much on it . but it seems that this is a...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 4:16 am
lallu_jaya (9/21/2010)
My question is where did this date come from?
post the query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 1:24 am
lallu_jaya (9/21/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 1:05 am
Craig Farrell (9/21/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 12:45 am
Craig Farrell (9/20/2010)
There's your 15 gig bump, needed snapshot room.
can you please brief it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 21, 2010 at 12:14 am
Some more information about the concerned database :
1. Data file growth has been set to : 1 MB.
2. it contains 18000 tables,there are couple of heavy table...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 11:13 pm
Craig Farrell (9/20/2010)
What's your free space like at the moment? 🙂 It may have just needed room to work.
thanks for quick response :-).15 GB space to work ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 10:52 pm
Have you google it ? i am not sure you can get any script which will work for both table and SP. but individual script will be there. So happy...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 10:44 pm
Adiga (9/20/2010)
You may find this article useful.
Thanks but as i mentioned that i have 64 bit machine and this resolution is for 32 bit machine.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 6:48 am
Jamie Julius (9/18/2010)
The reason I asked is because the table in question is very large (about 1,000,000 records).
Still using table variable for heavy volume of data. i would suggest...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 5:17 am
ananda.murugesan (9/20/2010)
2.SQL performance Condition alert - which is important counter to be monitor and configure counter name & threshold values for Alert received
Memory, CPU, IO usage.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 5:12 am
Sharon Kumar (9/18/2010)
please provide me trouble shooting steps,please help me out on this issue..
thanks
we can spend years on this topic. So refer this article it will give you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 4:56 am
Viewing 15 posts - 1,291 through 1,305 (of 2,462 total)