Viewing 15 posts - 631 through 645 (of 1,222 total)
You should specify a value for the sort key of the dimension - perhaps something line CONVERT (varchar, date, 112)
March 2, 2010 at 8:49 pm
Each instance on a server must have a different name. So what you are suggesting is not an option on the server.
You could configure your clients to use an...
March 2, 2010 at 8:36 pm
If you use a SSIS package, you need to consider how the package will be initiated. Wherever the application is running (e.g. on a workstation for a Win32 type...
February 23, 2010 at 5:11 am
The following is intended to get you started. You really need to have a hierarchy defined in your Customer dimension to get this to work. Once you have...
February 21, 2010 at 8:14 pm
DBCC SHRINKFILE is what you are after.
The following will shrinkfile 'datafile1' to 1000 MB
e.g. DBCC SHRINkFILE ('datafile1', 1000)
February 21, 2010 at 7:53 pm
I would create a sproc that run's as a user that has the privileges to start the relevant job. This is really easy to do and, given that the...
February 18, 2010 at 8:16 pm
You are correct - merge replication uses the Row Guid Column to identify each record.
February 15, 2010 at 9:38 pm
How about creating a SQL Agent Alert that fires when the log file is bigger than 50MB ? Get it to start a job that does the log backup.
The...
February 9, 2010 at 8:28 pm
How about creating a SQL Agent Alert that fires when the log file is bigger than 50MB ? Get it to start a job that does the log backup.
The...
February 9, 2010 at 8:27 pm
There are a bunch of system processes that are started when SQL Server starts. The time that these processes start is effectively the time that SQL Server started. ...
February 8, 2010 at 8:10 pm
First - check whether you are getting conflicts. Depending on how you have chosen to resolve conflicts, replication will update records with the contents from another server (which sounds...
February 7, 2010 at 8:52 pm
Have a read of your original post...yes you can. Just do what is suggested in your post
February 2, 2010 at 2:47 am
Can't explain what happened with table 2 but for table 1, I suspect that what is happening behind the scenes is
- the change in datatype is really implemented as
...
February 1, 2010 at 8:29 pm
in the RTM release of SQL 2005, mirroring was disabled as you are finding - database mirroring in the release is not supported by Microsoft.
This was changed in...
February 1, 2010 at 7:39 pm
Check the margins of your report. It looks like your page size is 21cm and your report width is also 21cm. If there is any margins on your...
January 26, 2010 at 8:13 pm
Viewing 15 posts - 631 through 645 (of 1,222 total)