Viewing 15 posts - 3,316 through 3,330 (of 7,503 total)
Good Job !
Nice article, well documented, good refs.
As documented, the general attitude for FK-indexes sould be : always implement FK-indexes, unless one can prove a particular index hurts, and then...
November 9, 2009 at 12:57 am
Sander A. (11/9/2009)
November 9, 2009 at 12:18 am
please post in SQL2000 forums for SQL2000 related questions.
@@version info does matter !! Please provide it.
- Did you perform any maintenance after the restore ?
- did you update statistics ?
-...
November 8, 2009 at 2:05 pm
altering float to decimal(n,m) will cause your full table to be rewritten !
Best you can do to take control is - as Gail advised - create a new column (decimal)...
November 8, 2009 at 10:13 am
Having installed only the client tools ??
Did you already have a sqlinstance on your pc ?
Having only the client tools, just provide e.g. enterprise manager to be able to...
November 8, 2009 at 10:07 am
first of all, comfort the kid ! "Next time, no more luck, perseverance in the sports for the team will do the trick" π
I would take the 64-bit offer...
November 8, 2009 at 10:02 am
three options:
1) enable that logging into the errorlog (using sqlserver properties in SSMS), import it and filter it. That will nolonger be your first choice !
2) start a trace for...
November 8, 2009 at 7:52 am
and with Coalesce you can evaluate n replacement values.
Select coalesce(T.col1, O.colx, T.col2, 'I just don''t know')
from mytable T
inner join myothertable O
on O.fk1 = T.pk
November 8, 2009 at 2:38 am
So there must be some truth in it :w00t:
As always in fora, it's nice to get something confirmed, if possible even more than once.
November 8, 2009 at 1:48 am
32-bit always behaves like 32-bit... even on 64-bit.
So, the same rules apply for every 32-bit software.
If you can, install 64-bit software to overcome all 32-bit related problems.
32-bit uses WOW (windows...
November 8, 2009 at 1:29 am
- "exec sp_configure " will show all available configuration parameters.
Keep in mind you may need to activate "show advanced options" to get to see all parameters !
- Check books...
November 6, 2009 at 1:58 pm
Dave Ballantyne (11/6/2009)
Or my blog has a simple examplehttp://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/10/15/udf-overhead-a-simple-example.aspx
Very nice example, Dave !
Straight forward and very to the point !
November 6, 2009 at 6:59 am
Also have a look at one of the previous headlines of the daily newsletter:
"T-SQL Best Practices β Donβt Use Scalar Value Functions in Column List or WHERE Clauses"
November 6, 2009 at 6:46 am
I've attached a little primitive example that may get you started.
Run this using SQLCMD or using SSMS in SQLCMD mode;
I did put my scripts at c:\SQLCMD
-- write the output to...
November 6, 2009 at 12:51 am
Yes.. I thought of that... But creating a view in 80+ servers is hard task to do.. [w00t]
.
No that is not an issue at all !
Create a script for each...
November 5, 2009 at 2:18 pm
Viewing 15 posts - 3,316 through 3,330 (of 7,503 total)