Programming SQL

Design question
This is a design question. Here's hoping Joe Celko haunts this newsgroup ;) The relevant DDL will be at the bottom of the post. We have two entities -- sporting events and "product" which could be a cup, shirt or a fee. Obviously, events have a number of attributes not needed for "product". The natural PK fo... 27 Feb 2010 16:35

How Can I establish connection 16bit o.s MS DOS 6.22 to to SQL Se
> We have to establish a connection SQL Server on 16-bit MS DOS 6.22 o.s Tested Methods: ISQL.exe, Osql.exe; Conclusion: Both exes can not be run on the 16-bit DOS operating system. The last SQL Server version that included 16-bit Windows binaries was SQL Server 6.5. Mainstream support for that version e... 27 Feb 2010 14:22

Does somebody understand what they mean here. Some of it is about Integrated security
> Assume I use Integrated Security. I have two windows accounts one account Tony that I use when logging in to the machine and the other is ASPNET that IIS is using. How can I see in Sql Server what access rights these two accounts have. None of these two account exist in Sql Server. Be aware that... 27 Feb 2010 13:16

0xC0207015 error in SSIS but not DTS
Folks, I have DTS jobs that I moved to a SQL 2005 server which run fine when I execute them manually as 'legacy' jobs. However, when I try to schedule them (run them via SSIS), they generate this error: Error: Code: 0xC0207015 Source: DTSTask_DTSDataPumpTask_1 DestinationFile [43] Description: Ther... 28 Feb 2010 04:33

Preferred file group
Our application records transactional events (maybe 300K to 500K rows per day) on a separate file group called HISTORY. I was wondering if there are performance considerations when creating indices on this history table. That is, do I get a performance improvement if the index resides in the default file group or ... 27 Feb 2010 14:22

Case statement strangeness
Given that this query is easy to understand: Select case 'Rep' when null then 'SBr' else 'Rep' end .... it returns "Rep", as we expect. (These are internal codes for us.) Why is this one unusual? Declare @VA As Char(1) Select case @VA ... 27 Feb 2010 22:05

separte text
Hi, I have a query setup as a trigger below in sql 7: declare arow cursor for select sonitem, spart, soq, sdisc, sunitprice, sprice from salesitems where sona = @xson and soq>0 open arow while 1=1 begin fetch next from arow into @xitem,@xpart,@xqty,@xsdisc,@xsunitp,@xsprice if @@fetch_st... 27 Feb 2010 07:44

sys.dm_db_missing_index_*
Have the sys.dm_db_missing_index_* DMV's proven to be useful? ... 26 Feb 2010 10:47

Problem with sp_tables_rowset
i was running the profilier to fine tune and view the events and found that each 7/8 row is call the procude exec dbname..sp_table_rowset;2 null , N'table'. i am not clear why this many times a sp is being called off. one more table with single row and three columns is called if every 4/5 row. i need to talk to the pro... 26 Feb 2010 13:06

Refresh SQLServer Local Cache
When i m using Refresh Local Cache in Local Server its Working properly. But when i Connect to Remote Server then its not Working Can you tell me is their is any Solution or Issue with this, Or I have to Use RED GATE TOOLS for Refreshing Cache ... 27 Feb 2010 00:13