Viewing 15 posts - 56,056 through 56,070 (of 59,072 total)
Start with OSQL -L
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:35 pm
I agree with Aaron and Remi... there is no need for any dynamic SQL here. Also, you must follow Aaron's suggestion for how to test for the presence of a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:31 pm
Bond a DBA or whatever is necessary, but no matter what the circumstance, the DBA must be a trusted individual in order to protect the very security required by SOX......
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:27 pm
First of all... INT is NOT capable of storing a 16 digit number so just forget about that.
Serqiy's idea is great but you must take that one step further... every...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:22 pm
And, to add to Seqiy's good questions, what does the table parameter look like? Is it merely 2 dimensional or is it N dimensional?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:16 pm
Thank you for the high favor Mr. Polecat.
David is correct, though... take a peek at the link he provided for the "unstable" version ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:13 pm
You are correct.... I don't make the same argument against Redgate because they ligitimately advertise instead of resorting to spamming a forum. Your product is well founded... your advertising method...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 11:05 pm
Execute DBCC UPDATEUSAGE(0) for the current database and then take a look at the ROWS column of the sysindexes table. If you join the ID column of sysindexes with the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 9:24 am
Arthur,
The only thing that you have to remember is that if anything comes between the statement that creates the row count and the insert, then you'll need to use James'...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 9:04 am
Perfect... Couldn't have said it better... and have been through this with these folks more than once. Almost nothing worse than folks that spam forums.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 8:58 am
Even if you don't build views on the sorted view, consider this... what if you want the data from the view to be in a different order? The view will...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 8:52 am
Ummmm, why can't you just use a simple insert statement???? ![]()
INSERT INTO #Log (MessageCount)
SELECT LTRIM(STR(@@ROWCOUNT))+'...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 7:35 am
What? No shameless product spam, James? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 7:31 am
Here's a few more links from the Google search...
http://www.vesigo.com/SQLServer/DatabaseServerComparison.aspx
http://www.promoteware.com/Module/Article/ArticleView.aspx?id=23
http://builder.com.com/5100-6388-1054385.html
http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1211452,00.html
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 6:58 am
Here's a couple of other things from a more recent article that compares MySQL 5 against SQL Server... these things are crucial, in my book, and favor SQL Server... a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 21, 2007 at 6:13 am
Viewing 15 posts - 56,056 through 56,070 (of 59,072 total)