Viewing 15 posts - 17,956 through 17,970 (of 19,564 total)
As per the question concerning running a script from a folder or needing to create a new script. That depends - both are viable options.
January 22, 2010 at 8:32 am
Roy Ernest (1/22/2010)
I hope he is not trying everything in the script folder on production ... 🙂
Hmmm - depends. Production might just be his desktop
January 22, 2010 at 8:31 am
Roy Ernest (1/22/2010)
I do not know if this is a joke... :unsure:I am keeping away from it...
I'll take that risk. See where it goes.
January 22, 2010 at 8:06 am
To get results from a table, you do this:
Select * from yourtablename
It sounds like you did this:
create table yourtablename (col1 varchar,col2 varchar)
Or something to that effect.
January 22, 2010 at 8:05 am
Alvin Ramard (1/22/2010)
CirquedeSQLeil (1/22/2010)
Kit G (1/22/2010)
P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do...
January 22, 2010 at 8:03 am
Kit G (1/22/2010)
Quis custodiet ipsos custodes?(Who watches the watchers?)
Illuminati
January 22, 2010 at 7:55 am
Kit G (1/22/2010)
P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do anything...
Bet that's...
January 22, 2010 at 7:51 am
In addition to query tuning, and Index maintenance - I suggest proper indexing.
Another expensive option is to replace your disks with solid state disks or flash drives - very very...
January 22, 2010 at 7:49 am
Jeff Moden (1/21/2010)
What? No pork chops? :hehe:
What was microsoft thinking on this one?:-D
January 22, 2010 at 7:40 am
Lynn Pettis (1/22/2010)
CirquedeSQLeil (1/21/2010)
It was cheaper back when I was interested in attending there.There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program
Can't...
January 22, 2010 at 7:38 am
I would go so far as to increase the tlog backup interval to every 5 minutes during index rebuilds / reorgs
January 21, 2010 at 11:16 pm
Keep in mind that you will have to query while the tempdb is growing.
January 21, 2010 at 10:55 pm
It was cheaper back when I was interested in attending there.
There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program
January 21, 2010 at 10:46 pm
Viewing 15 posts - 17,956 through 17,970 (of 19,564 total)