Viewing 15 posts - 3,046 through 3,060 (of 7,191 total)
In that case, I think Lowell's solution nails it!
John
September 9, 2015 at 7:08 am
What would be your expected result set from these rows?
1 1
2 1
3 0
1 0
2 1
3 0
3 1
John
September 9, 2015 at 6:00 am
In that case, there's absolutely no reason I can see to use a maintenance plan for this. Please try changing the job step to T-SQL and see whether that...
September 9, 2015 at 5:10 am
Why are you using a maintenance plan for this? Maintenance plans are what their name suggests - for backups, updating statistics, consistency checks and so on.
The query in your...
September 9, 2015 at 4:08 am
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
Viewing 15 posts - 3,046 through 3,060 (of 7,191 total)