337 reputation
213
bio website
location
age
visits member for 1 year, 9 months
seen 2 hours ago

SQL Server Developer and DBA. Former software developer.


Mar
28
awarded  Popular Question
Mar
6
comment Dealing with measure groups of different granularity
When you say "that doesn't seem to allow me to use the Referenced dimension usage for other dimensions," what do you mean? What steps have you tried?
Feb
14
revised How can I search SQL Server for maintenance plans that execute specific tasks?
added 9 characters in body
Feb
14
comment How can I search SQL Server for maintenance plans that execute specific tasks?
I do have a question though...how is it possible to deploy an SSIS package w/ project model as an official maintenance plan?
Feb
14
revised How can I search SQL Server for maintenance plans that execute specific tasks?
added 201 characters in body
Feb
14
comment How can I search SQL Server for maintenance plans that execute specific tasks?
That makes sense. You can still make maintenance plans in SSMS without the wizard, and they will be deployed to msdb. But yeah, anything deployed via the project model would not apply to this solution. I'll edit my answer to note the limitations.
Feb
14
awarded  Self-Learner
Feb
13
comment How can I search SQL Server for maintenance plans that execute specific tasks?
No, this works in 2012. AFAIK, there is only one deployment method for a maintenance plan - saving the plan, which stores it in msdb, no different than the prior versions. And the project deployment model is only an option for custom SSIS packages.
Feb
13
comment How can I search SQL Server for maintenance plans that execute specific tasks?
Please somebody help w/ the code formatting. I tried, and failed.
Feb
13
asked How can I search SQL Server for maintenance plans that execute specific tasks?
Feb
13
answered How can I search SQL Server for maintenance plans that execute specific tasks?
Dec
4
comment Why does SQL Server require the datatype length to be the same when using UNPIVOT?
An alternative that allows you to overlook the need for specifying the length is to cast each as SQL_Variant: sqlfiddle.com/#!3/13b9a/2/0
Dec
4
comment Why does SQL Server require the datatype length to be the same when using UNPIVOT?
My guess (sorry, can't find anything to back this up)...the results are stored into a new column. SQL creates the metadata for that new column based on the largest type/length combination. If the requirement is that the source column metadata must match the destination column metadata, then length would be included with type.
Dec
4
comment Why does SQL Server require the datatype length to be the same when using UNPIVOT?
I overlooked that, and yeah, the IN operator typically doesn't care about the length.
Dec
3
answered Why does SQL Server require the datatype length to be the same when using UNPIVOT?
Dec
3
comment Don't rebuild indexes < 1000 pages - then why bother having them?
@RemusRusanu your link indicates that you recommend shrinking data files to reduce index fragmentation, when it seems that all other SQL experts that I'm familiar with are very passionate about how they do not recommend shrinking data files, and how shrinking can cause index fragmentation. (See brentozar.com/archive/2009/08/… and sqlskills.com/blogs/paul/…). Care to elaborate?
Oct
10
awarded  Popular Question
Jul
9
comment Invalid object name 'master.dbo.MSreplication_options' when restoring DB
You could try using sp_removedbreplication to remove all replicated objects from the database, which should clean up all the residual stuff from the publisher copy. However I'm not sure how it would affect the subscription going forward. It may have to be re-configured. msdn.microsoft.com/en-us/library/ms188734.aspx
Jul
9
comment Invalid object name 'master.dbo.MSreplication_options' when restoring DB
At this point, are you able to run 'ALTER DATABASE <name> ONLINE'?
Jun
27
awarded  Yearling