Viewing 15 posts - 136 through 150 (of 198 total)
I have the same problem. What I do for seeing a report is to export to pdf from Report Designer preview. I know that my approach does not fix the problem, altough...
June 22, 2007 at 7:53 pm
sal, Mihai; try changing to UNION ALL before looking for any other fixes. UNION is equivalent with SELECT DISTINCT - it looks for duplicates;
Hope this helps;
June 22, 2007 at 4:06 pm
This is a normal behaviour for a bulk insert process. I would say, instead to expand the disk, create a second log file in a separrate disk. Simple recovery model is...
June 22, 2007 at 4:00 pm
In your first post you said that you have an ETL app that loads data from text files (source) into a sql database and the way this app is written...
June 21, 2007 at 7:31 pm
Assuming you've already installed dbmail on your instance then the code should look like:
SET
ANSI_NULLS ON
GO
SET
June 21, 2007 at 7:07 pm
The answer is yes. If you have already a sql 2005 instance installed then you can install a named instance of sql 2000 on the same machine. The idea is to...
June 21, 2007 at 6:55 pm
You would need to create a local admin account - create a normal local account then add it to the local admin group - for your sqlserver service. If your sql server...
June 21, 2007 at 3:21 pm
I would say to optimise the query in the view first, then build an index on your view - use DTA for this; after that you can think to spread...
June 21, 2007 at 1:12 am
Although there is a potential performance benefit to use multiple files and filegroups, the main reason you would consider implementing them would be for easier administration. When you use multiple...
June 21, 2007 at 12:48 am
The live feed system cannot be normalised for now
Is "the feed system" a sql DBA task? Instead I would seriously think to implement unique keys on either surrogate key fields of the sql tables...
June 21, 2007 at 12:01 am
SQL Server 2005 executes as a set of Windows services. Each service can be configured to use its own service account. This facility is exposed at installation....
June 20, 2007 at 8:19 pm
I would like to install the 2k8 ctp on a vista machine; I have already a 2k5 developer (named) instance installed. I've read that the 2k8 ctp does not work yet with many...
June 19, 2007 at 5:40 pm
The SQLAgentReaderRole can view any jobp; can modify job properties only if the job is owned by the person with the role. I use this frequently and it works.
June 18, 2007 at 7:35 pm
June 18, 2007 at 12:42 am
Viewing 15 posts - 136 through 150 (of 198 total)