Viewing 15 posts - 19,906 through 19,920 (of 26,490 total)
If you are using the Express Edition of SQL Server, SQL Server Agent is not included, and you can't download it either. If you need to run scheduled jobs...
July 7, 2009 at 11:45 pm
It should be noted, iirc, that if you want to write code that will port directly to Oracle, all object names need to be created and typed in UPPER CASE....
July 7, 2009 at 11:40 pm
No. It all comes down to company standards and/or personal preference.
As a former co-worker once stated, Standards are great and every one has one.
If SQL Server required all UPPER...
July 7, 2009 at 11:38 pm
What do you want to occur when both Field1 and Field2 are null? Leave them null?
July 7, 2009 at 3:00 pm
Nope. Native Backup Compression is only available in SQL Server 2008 Enterprise Edition.
July 7, 2009 at 2:51 pm
Probably not without some convoluted dynamic sql since it looks like you want to exec the query stored in the table as part of selecting data from the table.
July 7, 2009 at 2:04 pm
How big are some of the tables? If you are doing a full scan, it could take awhile on fairly large tables.
July 7, 2009 at 12:56 pm
Sounds like an audit table is needed to capture this info for future analysis. What you are looking for you can find in Books Online, the SQL Servr Help...
July 7, 2009 at 12:53 pm
mpv (7/7/2009)
I don't see what you did, other than adding code to create the tables with data. I assume you are implying that I need to do this whenever I...
July 7, 2009 at 12:47 pm
ramdas.narayanan (7/7/2009)
In the result Ram has one class in feb as per the data...
SELECT teacher,
Jan=SUM(CASE WHEN DATEPART(m,Date)=1 THEN 1 ELSE 0 END),
Feb=SUM(CASE WHEN DATEPART(m,Date)=2 THEN 1 ELSE...
July 7, 2009 at 12:43 pm
I agree with Wayne on both points. I have the same article referenced below in my signature block as well. It is the first one regarding asking for assistance.
July 7, 2009 at 12:35 pm
First question I'd ask is what is the error message? Can't diagnosis a problem from this "returned an error message".
One possiblity, highly fragmented disk and the SQL Server couldn't...
July 7, 2009 at 12:32 pm
How many tables in the database? I have a database with over 50,000 tables and the update stats takes awhile even though many of the tables are empty.
July 7, 2009 at 12:29 pm
I missed too! I knew the correct answer, if I had noticed it was using table variables. Missed that, choose the wrong answer.
July 7, 2009 at 12:23 pm
Perfect, just what I wanted to see. thank you for posting your final code as well for others to view.
July 7, 2009 at 12:07 pm
Viewing 15 posts - 19,906 through 19,920 (of 26,490 total)