Viewing 15 posts - 16 through 30 (of 140 total)
Can you see the correct format if you view the cube from Analysis Services?
To drill down in Excel double click the cell you want to drill down on. To Drill...
November 25, 2004 at 10:22 pm
These aren't error messages. They are messages generated by whatever third party backup tool you are using at a file level. I'm guessing you have a third party tool with...
November 25, 2004 at 5:49 pm
I'm not sure if you have a partitioned view, but does this help?
http://support.microsoft.com/default.aspx?scid=kb;en-us;270013
If this doesn't help maybe try recreating the view anyway?
November 22, 2004 at 11:39 pm
I boost the priority on all my SQL Servers. They are only running SQL Server though. If your server is a dedicated SQL box, it won't hurt things to check...
October 13, 2004 at 12:59 am
Sounds like it is definately a network problem. Have you monitored whats happening on the network and the NIC/s on the SQL box when you're running the backup?
Do you get the...
August 30, 2004 at 7:23 pm
Have you checked to see what your CPU load is? I had the same problem when trying to load a huge amount of data and CPU was hitting 100%.
I ended...
August 30, 2004 at 12:05 am
It turns out a Developer had added an index that included a computed column. There was no data in the table (and is unlikely there will be) and the developer...
August 29, 2004 at 10:24 pm
If you are referring to Auto Create Stats and Auto Update Stats, you can view this by right clicking your database in Enterprise Manager, click properties, and then choose the...
July 26, 2004 at 8:02 pm
I first started using SQL Litespeed a few years ago when it was owner by an Australain company called DBAssociates. I found their version of the software great and I...
July 26, 2004 at 7:29 pm
I run my DBCC CheckDb's with my Index Defrags over the weekend. Since our databases are quite large and it would throw out our backup window if I ran them each...
July 25, 2004 at 11:37 pm
Hi Levi,
Enterprise Manager will show seconds in the "last run time", you are right, but when you schedule it you can only specify minutes and hours, that's why it will...
July 20, 2004 at 10:26 pm
Levi,
How are you scheduling your jobs? You can only specify hh.mm through Enterprise Manager. If you want it to start on hh.mm.ss you will need to use sp_add_jobschedule.
How are you...
July 19, 2004 at 11:32 pm
Local Administrator rights should be enough for a DBA, you don't need to be a Domain Admin, even though I am a Domain Admin at my site. If you have...
July 9, 2004 at 1:11 am
I passed this exam last week. It was my favourite exam out of all the SQL exams. I didn't find it too hard and a lot of of the questions...
June 28, 2004 at 8:23 pm
Every time I install a SQL Server I have the same problem as you, except I want English (AUST). This is what I know:
When you install SQL Server it automatically looks...
June 15, 2004 at 12:53 am
Viewing 15 posts - 16 through 30 (of 140 total)