How does one get their head around OLAP? [more inside]
posted on Feb 10, 2008 - 4 answers

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted on Nov 29, 2007 - 3 answers

SQL SERVER - I'm not a SQL script guy, but I've got a SQL script problem. [more inside]
posted on Sep 17, 2007 - 6 answers

SQLServer Express remote connection problems. Please hope me! [more inside]
posted on Nov 2, 2006 - 9 answers

SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted on Oct 21, 2006 - 4 answers

I have a Windows-served website programmed in C# and connected to a SQL database. I'd like to move the whole thing to the Mac. [more inside]
posted on Feb 24, 2006 - 8 answers

What is the optimum way in an ASP.NET Web Application with SQL Server 2000 to perform the following data correlation? [more inside]
posted on Jan 19, 2006 - 2 answers

I currently have a very low level of SQL knowledge (I can construct simple queries for multiple tables, but I start to fall apart on the difference between inner and outer joins). I need to learn to create multiple join SQL queries and Dynamic SQL/Stored Procedures on MS SQL Server 2000 in a short period of time. I'd also like to learn to use MS Query Analyzer more efficiently. Is there one book or online resource that is best for this? Additionally, are there alternatives to using MS Query Analyzer, or is that really *the* tool? [more inside]
posted on Jul 12, 2005 - 12 answers

I am trying to implement SQL mail fonctionnality for monitoring purpose under win2k / sql2k, only problem is to be configurer properly it must first obtain its parameter from Microsoft Mail API (MAPI) thru an already configured mail account, these are production servers and i don't feel too good about installing Outlook or Outlook express just to get an account configured so i can use this fonctionnnality. is there a way around this ? I am aware of several monitoring solution offered by third parties and i accept proposition (please no astroturfin') but I want to get that build in feature to work first.. anyone ? Thanks Selfsck
posted on Mar 15, 2005 - 4 answers

I am having a problem with our account app / server; I need to apply a hot fix to the sql db and the files are encrypted. When trying to decrypt the file, I get varied error messages. Any MCSE / encryption Guru's in the house? [more inside]
posted on Mar 11, 2005 - 1 answers