Viewing 15 posts - 3,046 through 3,060 (of 7,187 total)
I don't think it's possible to cluster an unclustered instance like that. To avoid future problems, I think you would be best to uninstall SQL Server and reinstall as...
September 9, 2015 at 4:01 am
Since the package file is stored under your own user folder, I would say that it's very likely the SQL Server Agent service account doesn't have access to open it....
September 9, 2015 at 3:59 am
If it's an option for you, concentrate on cleaning the data. You're always going to find edge cases that you hadn't accounted for - maybe the two parts of...
September 8, 2015 at 8:05 am
I've never used it before, but I think SQL Compare from Redgate will do that for you.
John
September 8, 2015 at 2:02 am
No, if you change, for example, varchar(100) to nvarchar(100), the column width increases from 100 bytes to 200, but the only thing that changes in the column definition is the...
September 7, 2015 at 5:52 am
Script the tables out and use Find and Replace in Management Studio to replace nvarchar with varchar.
John
September 7, 2015 at 2:19 am
You can't do it directly, but you could have the first job write the parameter values to a database table, and the second job read from that table.
John
September 7, 2015 at 2:13 am
Max memory means maximum memory that can be used, not memory that is actually being used. So just because max memory is set to 100GB, doesn't mean you're using...
September 3, 2015 at 9:37 am
It's got to be TextData, hasn't it? That's the only string or binary column that's being inserted. Looks like you've captured events in your trace that have more...
September 3, 2015 at 8:14 am
Thanks for the clarification. So, as I first thought, you have 128GB, of which only 4GB is free. SQL Server is using 24GB. What is using the...
September 3, 2015 at 8:10 am
ZZartin (9/3/2015)
September 3, 2015 at 8:05 am
How so? You've set it to use max 100GB, and it's using 24GB. You need to find out what's using the other 100GB.
John
Edit - although you've changed your...
September 3, 2015 at 7:43 am
Have you checked which processes are using that memory?
John
September 3, 2015 at 5:46 am
Message boxes are fine when you're running the package interactively, but what if you forget to take them out and then wonder why the package fails when you schedule it?...
September 3, 2015 at 5:23 am
Do you have any other applications or SQL Server instances running on the same server? What is the value of max server memory?
John
September 3, 2015 at 5:20 am
Viewing 15 posts - 3,046 through 3,060 (of 7,187 total)