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...

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...

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...

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

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.

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...

- "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...

Very nice example, Dave !

Straight forward and very to the point !

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"

http://www.sqlservercentral.com/redirect/articles/68642/

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...

No that is not an issue at all !

Create a script for each...

have a look at Books Online ( highlight your "convert" keyword and hit Shift+F1 if your query pane )

That will open your local copy of books online and show info...

KP-249943 (11/5/2009)

---

Hi,

We have a SQL Server 2005 (SP3), Enterprise (64 bit) edition.

The data is on the H:\ drive. The Transaction Log is on the F:\ drive. Both H:\ drive and...

also have a look at the demistifying article Gail Shaw posted http://www.sqlservercentral.com/articles/64582/

scheney-1152259 (11/5/2009)

---

Hi there,

From what I've seen this question gets asked quite a bit, but I can't get a solution that works for me.

I am running a database using SQL Server...