Viewing 15 posts - 56,056 through 56,070 (of 59,067 total)
Thank you for the high favor Mr. Polecat.
David is correct, though... take a peek at the link he provided for the "unstable" version
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...
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...
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'...
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.
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...
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))+'...
June 21, 2007 at 7:35 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
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...
June 21, 2007 at 6:13 am
And, they would have to rewrite any existing code because the many of the advanced SQL Extensions in both are different... SQL is NOT SQL
June 21, 2007 at 6:05 am
IF OBJECT_ID('TempDB..#FileExist') IS NOT NULL
DROP TABLE #FileExist
Make sure the name of the table is correct.
June 21, 2007 at 12:13 am
Alvaro... really, really bad idea to sort in a view... really bad...
June 20, 2007 at 11:56 pm
Like everyone has stated... bad idea. Should be done with reporting software or a GUI if you have one. I, too, question the table design for having what appears to...
June 20, 2007 at 6:05 pm
Viewing 15 posts - 56,056 through 56,070 (of 59,067 total)