Tim Mitchell (5/31/2012)

---

Same here, but tired for a different reason. I went to the Rangers game last night and watched our boys get shelled at home by the Mariners....

jfogel (5/31/2012)

---

Our app did not try to use say ANSI only SQL, the "mode" is detected and either Oracle or SQL Server specific code is executed within executables. For...

On our list. I'll try to get an ETA on development.

You can set the default locations for data and backup files in setup.

For the system files, the master location is passed as a parameter in the service applet (or the...

Pick up Michael Coles' book on Pro SQL Server 2008 Encryption

Are you running x86 (32 bit)? If not, don't worry.

If you are

http://blogs.technet.com/b/rob/archive/2008/05/15/windows-memory-and-sql-server.aspx

http://msdn.microsoft.com/en-us/library/ms175581(v=sql.105).aspx

Powershell can work outside of SQL Server and is less cumbersome than stringing scripts through SQLCMD. That provides a good way to handle administrative tasks, especially when they involve the...

use a batch file. In it

sqlcmd -E -Q "sp_detach_db @dbname='mydb'"

They can double click the batch file to detach the database.

second vote for what Lynn said. If you provide some DDL and sample data, we can probably help.

I suspect that an inner join is needed as well. When you gather...

Seth has a good explanation, though I don't know I'd assume a trigger is being used. A stored proc can do this well.

The issue is you can't turn off encryption...

distinct won't just look at the productID. How can the engine tell which row to discard if it does? Is it the row with the lower price? The higher one?

You...

Robert Domitz (5/30/2012)

---

I, for one, am a programmer: my expertise is in designing and building software. I am not a writer, nor do I aspire to be one....

I hope people aren't rating the article down because it uses FTP and not SFTP. That's what SSIS provides, and we wanted to give a tutorial on how to use...

you are welcome.

SP4 is pretty stable, and should be fine. Note that there are some post-SP4 patches that you might want to apply as well as a few are...

We had a speech at an event yesterday from the American Legion post here in town that addressed this. It is happy so...