My cube has 12 monthly partitions. After it processed a few partitions, I got the error: "Memory error: Allocation failure: Not enough storage to...
One of my SQL users needs to run DBCC traceon command. That command requires sysadmin permission to run. But I do NOT want to grant this user as...
On previous SQL 2000 server I can easily estimate the total space used and the percentage of free space left in each database file by right click...
I run DBCC Shrinkfile command on my SQL 2005 server. Does DBCC shrinkfile requires OS resources, such as memory, CPU usage? How much does it cost?...
I run sp_who2 to check SQL server 2005 activities. I find some SPID with Status=SUSPENDED. What does this mean? Thanks for help! George
A user in my team created a report by using Report Services 2005 from "Business Intelligence Developer Studio" tool. When he tried to "Deploy Report...
My Analysis service 2000 used work fine. But recent days it generates lots SQLDmpr###.mdmp files. What are they? My process cube takes much long time...
I have SQL Server 2005 installed on my XP desktop. The installation went smooth. But after it completed, I can not see "Management Studio", "Business...
I am not able to start SQL Server 2005 Agent Service. Current I have SP2 installed. The error message shows: "SQLAgent$SQL2005 service started and...
I have SQL Server 2005 Trial version installed on my XP desktop. Now I receive SQL Server 2005 Developer Edition CD (legal one). Do I have to...
Are there any articles to direct me to create a SQL job which can execute SSIS package on SQL server 2005? By the way, on SQL server 2000 I use...
Is it possible to browse SQL 2005 SSAS cube byhttp:// ? If yes, how to do it? Thanks, George
Hi, I create a report by using Visual Studio. When I tried to "deploy report", I got the error: "Deploying tohttp://server01/ReportServer Error...
When I tried to accesshttp://localhost/Reports from my server, I got error: 'rsReportServerDatabaseUnavailable'. How can I fix this issue to access...
I want to use the features of SQL Server 2005 Reporting Service. Can I only install SQL 2005 Reporting Service component on my existing server which...
Are there any utilities to take care the issues of data fragmentation, especially on SAN storage disks? Thanks for recommendation,
How database optimization works on SQL server 2000? Each time when I add new database files into my database or delete database files from the DB,...
I use DBCC SHRINKFILE with EMPTYFILE option on SQL 2000 server to empty one file and move its data to other 5 files in the database. So I can delete...
On my SQL 2000 server I have SQL jobs to run DTS packages. Sometimes I need to cancel or stop the jobs before they completed. I find out that even...
Separate names with a comma.
