Viewing 15 posts - 2,971 through 2,985 (of 7,429 total)
I will say just to teach you how to understand to read the Log file with just the basic SQL Tools is a pain but could be done. LogExplorer is...
May 16, 2003 at 2:38 pm
Are you meaning you want to do something like this.
SELECT col1,col2,col3,
SUM(CASE WHEN col4 = @val THEN col5 ELSE 0 END) AS EMP from sample
group by col1,col2,col3
May 16, 2003 at 2:33 pm
quote:
* Use CONVERT() instead of CAST* Use INT OR TINYINT for boolean values instead of CHAR Y/N
* Use VARCHAR instead of CHAR
May 16, 2003 at 5:26 am
Thinkning about this. Did you have a failure at anytime where you had to rebuild the DB and restore data? Or have to moved the DB from another server between...
May 15, 2003 at 5:14 am
About the best I have come across (but even then it is kinda iffy) is the one at http://www.codeguru.com/forum/
May 15, 2003 at 3:34 am
Please do not cross post. Leave/read responses in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12205&FORUM_ID=5&CAT_ID=1&Topic_Title=Rebuilding+Indexes+on+System+Tables&Forum_Title=Administration
May 14, 2003 at 12:29 pm
quote:
We are mainly an internal SQL Server shop, but moving towards DB2/UDB. Our software (which we sell) is being pushed on DB2...
May 14, 2003 at 12:25 pm
Just a correction there wd should read dw.
DATEADD(dd, 1 - DATEPART(dw, GETDATE()), GETDATE())
However if you want to always get the Sunday date without having to do anything more in your...
May 14, 2003 at 6:32 am
I have begun to experiment with FileMakerPro http://www.filemakerpro.com/ just because.
I hit a lot of Oracle servers that are running behind many of the production systems here (mostly large scale datawarehouses...
May 14, 2003 at 3:56 am
Actually just to throw in here. It is common to expect this since so many system stored procedurs do. But if you will run sp_helptext sp_dboption you will see that...
May 14, 2003 at 3:43 am
No, that is your easiest solution or you could BCP out the data and script the objects then do the same thing.
May 13, 2003 at 7:25 pm
I covered this in the following article http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp
May 13, 2003 at 3:31 pm
You should then covert what I said to LEFT JOIN I do believe and should be the same.
May 13, 2003 at 3:29 pm
If I come across anything else I will pass along.
May 13, 2003 at 7:48 am
Viewing 15 posts - 2,971 through 2,985 (of 7,429 total)