Viewing 15 posts - 9,361 through 9,375 (of 9,641 total)
I enjoyed reading the article as I use articles like this to help me determine what SQL Server skills I am missing that I should have. I also think...
October 15, 2007 at 6:57 am
Thanks Grant. Are you searching/querying against the XML column? Do you return the data in the XML column as rows and columns or just as XML?
October 12, 2007 at 9:18 am
No one has asked yet, but what is the size of the DB and what is it's growth. Perhaps there are enough transactions to warrant 9GB Log size to...
October 11, 2007 at 1:26 pm
My "no trigger is a good trigger" comment was meant to be facetious. There are those who believe triggers are "hidden" code and should be avoided at all costs....
October 11, 2007 at 1:13 pm
1. I should add a FK Constraint on my Employees table to my StatusSub table (I realize that this won't guarantee RI, but it could be of help)?
Correct. This...
October 11, 2007 at 12:26 pm
Ahhh, glad my brain works a little bit out of SQL anyway.
As far as doing something wrong, nope you are not. The problem with the 2 table design is...
October 11, 2007 at 10:03 am
My preference it the two-table approach. It means more coding on the SQL Server side, but allows more flexibility in the application. Again that is preference.
If...
October 11, 2007 at 9:05 am
I was under the impression, at least with SSRS 2000, that if you used a different webserver you had to have SQL License for both servers. Is this true...
October 11, 2007 at 7:28 am
I had this issue pop up on my once and found the fix in BOL. I was under the impression that the 2 collations you encountered were the same....
October 11, 2007 at 6:55 am
dandrade (10/9/2007)
October 11, 2007 at 6:28 am
What are you using for security to connect to the FoxPro database?
October 11, 2007 at 6:21 am
Wouldn't a simple query with grouping on Col2, COl3, and Col4 return the results you want, so you could process them in the C# application. Something like:
Select
...
October 10, 2007 at 6:41 am
If you have SQL 2000 why not do it SSRS (SQL Server Reporting Services) which is an add-on included in your license. A phone list is a 20 minute...
October 10, 2007 at 5:58 am
According to BOL you could use the return value of the sp to determine if the message succeded. Like this:
Declare @RetVal Integer
Exec @RetVal = sp_send_dbmail @recipients=@To, @subject...
October 9, 2007 at 3:16 pm
As has been mentioned I don't see any aggregation going on so there is no real reason for a group by. Also I notice you are using Left Outer...
October 9, 2007 at 2:56 pm
Viewing 15 posts - 9,361 through 9,375 (of 9,641 total)