Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-02-14 : 05:44:24
|
| This one is a real test - you may detect a common theme. If the answer to question 1 is no then you don't need to answer the other questions1) Have you heard of trace flags (before reading this)?2) Do you use any documented ones?3) Do you use any undocumented ones (and if so which)There wasn't that easy? As you may guess I have only just discovered these and am interested in the potential but was wondering if anyone had hit any problems with any of themsteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-14 : 05:57:48
|
| 1) yes2) yes3) yes - usually only to affect recovery when someones messed up a server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-14 : 12:40:39
|
| 1) yes2) yes - usually for deadlock debugging3) no - haven't had to yet, but I know about themTara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-02-14 : 12:46:58
|
| 1) Yes2) Yes, if Tara tells me to3) No, but I will it Tara tells me to!Kristen |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-14 : 13:26:25
|
| 1) Yes2) No3) NoBe One with the OptimizerTG |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-14 : 14:33:51
|
| 1) Yes2) No, never really needed to3) Yes, just 257 to make xml output more "readable"rockmoose |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-02-14 : 19:08:28
|
| 1) Yes2) No3) Yes, to move the master/temp/msdb to new drive. I thought "-T3608" were doc but are not.Tim S |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-02-15 : 03:18:55
|
| 1) Yes2) Yes, to investigate locks and deadlocks3) No--------------------keeping it simple... |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-02-15 : 08:20:52
|
| Nx3 |
|
|
|
|
|
|
New Survey