Viewing 15 posts - 931 through 945 (of 2,462 total)
tauseef.jan (10/1/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 11:59 pm
looping myself
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 11:54 pm
there will be few checks before staging build
1. sufficient space on log and data drives plus tempdb drives too
2. from where to keep backup files and all...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 11:50 pm
is it started happeinig at sudden ?
and
are you using same location for CSV file by both the job and manual process? because there could be space issue :unsure:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 11:42 pm
GO to the services and check the name of default instance ,you might be using wrong name
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 11:39 pm
ksr39 (10/10/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 2:55 am
My guess is, you would be using wrong file name
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 2:26 am
khushbu (10/9/2012)
first deletes that set of records and then inserts the record with the new value.
i dont think it will work same as you explained for SAME value updations:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 2:13 am
check the bootstrap folder or select @@version
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2012 at 2:07 am
neellotus07 (9/27/2012)
tell me should i create more clustered indexes or i need to create clustered index for fast query results.
TO create , add , remove or modify the indexes, first...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 1, 2012 at 2:10 am
nitin.varshney (9/27/2012)
When It is executing in Production, it is giving the performance impact.But the data populated in table variable is having approx 4000 records only.
You need to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 1, 2012 at 2:01 am
set the trace for that particular time interval and see what other and related stuff is running ? and other thing try to see the perf mon too (i suspect...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2012 at 11:15 am
jshurak (9/25/2012)
Why is primary file group backup growing like this?
Did you find that why PRIMARY group increasing at sudden?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2012 at 11:07 am
Jeff Moden (9/28/2012)So if you want a 12GB TempDB, are you suggesting to set the otherwise unused Model database to 12GB? Doesn't sound right to me. It's better...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 28, 2012 at 7:59 am
If thats a non-production environment where restart the sql services is possible. set the size of MODEL database. it will be get inherited when sql gets restarted
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 28, 2012 at 7:25 am
Viewing 15 posts - 931 through 945 (of 2,462 total)