Viewing 15 posts - 5,656 through 5,670 (of 7,429 total)
Did you run DBCC DBREINDEX against all indexes of that table? SOrry I have code on my machine at work that iterates all the indexes and does this but not...
May 31, 2002 at 3:23 pm
Have the customer launch Profiler and trace your acitivty to see if anything unusuall is going on, this seems like you are being disconnected from their end but I cannot...
May 31, 2002 at 11:26 am
Normally you would aim to normalize, the big factor though is how many transactions take place over a given time and what would be the effect of normalizing. If it...
May 31, 2002 at 11:07 am
You could try pinning the table but should be retained if used very often unless something else pushed it out. All I could say is test but there could be...
May 31, 2002 at 10:57 am
EM reall only does what Steve suggests but a little more with regards to permissions, constraints, triggers and so on by finding those renaming the old table build a new...
May 31, 2002 at 10:52 am
Can you describe what you are doing a bit better. There are many ways. including createing a field with a version number that you can alter to a new number...
May 31, 2002 at 10:48 am
Normally you would not, however it you will be working with a specific table for an extended period of time you may do this to prevent it from dropping from...
May 31, 2002 at 10:46 am
quote:
If it's not then I would like to find out why when I delcare something as a varchar(7999) it only will let...
May 31, 2002 at 10:38 am
1) Temp tables are stored in tempDB but once stored in they fit in memory it will not need to use the reference in tempDB.
2) When they are not longer...
May 31, 2002 at 10:33 am
Try using ping like so
ping 0.0.0.0 -t -l 1400
ANd see how many failures you get, if a lot then tracert to the server and see if you can find what...
May 31, 2002 at 9:31 am
Actually it is the same logic. WHen items are parse AND parse together and OR parse seperately, if you have X AND Y OR A AND B it will parse...
May 31, 2002 at 9:26 am
I also forgot, figures, don't use something long enough and you totally forget about it. However the one advantage with what I put out will give you is you can...
May 31, 2002 at 4:40 am
Could be the MDAC components on that machine are an issue.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 3:33 pm
From SQL7 BOL
extended memory size Option
The extended memory size option is available only for Microsoft® SQL Server™, Enterprise Edition running under future versions of Microsoft Windows NT®, Enterprise Edition, on...
May 30, 2002 at 1:07 pm
This should help. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=204
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 11:48 am
Viewing 15 posts - 5,656 through 5,670 (of 7,429 total)