Viewing 15 posts - 121 through 135 (of 145 total)
1. In an agent job, is each step atomic? i.e, if step 1 and 2 succeed but step 3 fails, are the updates done by step 1 and 2 rolled...
September 6, 2009 at 9:04 am
The problem is that the "report user" doesn't have some of the required permissions. Default settings are integrated security(which means windows authentication - yes i know it too ;pp) -...
September 6, 2009 at 8:48 am
Few weeks ago i finished a project where we were using a lot of hierarchical structures. We decide to use hierarchyId - it was a good joice! At the beginining...
September 6, 2009 at 8:06 am
Yes! all of us should do search in BOL before asking here/other places 😉 Books Online are really good, they have good examples (with code samples), and in many cases...
September 6, 2009 at 7:55 am
Last year I had some speakings about tempdb - unfortunetly my pptx are in polish - so maybe you can use this whitepaper to get more information: http://technet.microsoft.com/en-us/library/cc966545.aspx...
September 6, 2009 at 7:52 am
I can imagine that the recommendation looks like this:
1) first shrink your db
2) then rebuild your indexes
but if your ISV advice to shrink AFTER rebuild - it isn't an advice...
September 6, 2009 at 7:45 am
gives us some more information about what are your need ?
September 6, 2009 at 7:25 am
Paul, your idea is quite interesting but when you are using NewId() - there are "only" standard problems with indexes (you can use fillfactor and proper index defargmantation strategy to...
September 6, 2009 at 7:22 am
complex problem = security
- kerberos
- integrated security
- + linked servers ...
there is a lot of places when something could go wrong!
his problem means that the report is executed on a...
September 6, 2009 at 7:06 am
1) before upgrade you should use this tool
2) after restoring database on 2005 you should run dbcc updateusage (and maybe checkdb too)
September 6, 2009 at 6:56 am
are you sure that you __really__ need that diagram ? are you are going to print it ? 4k tables + views,procs, funcs?
much more usefull are tools like these:
SQL Doc...
September 6, 2009 at 6:52 am
im quite sure that you server has performance problems releted with slow IO or not enough memory. you shoud check the following perfmon counter: SQL Server : Buffer Manager :...
September 6, 2009 at 6:48 am
Maybe on failure you should use "Quit the job reporting success" ? Or maybe you can make a query against msdb.dbo.sysjobhistory ?
September 6, 2009 at 6:39 am
the biggest issue will occur during playing with clustered index
EE is quite nice, but an online option needs a properly setup tempdb (i.e. enough space)
September 6, 2009 at 6:31 am
I agree with Silverfox - a list provided by crainlee2 is not bad - but only on small environments. All of these tasks should be automated throud powershell/vb/tsql scripts. And...
September 6, 2009 at 6:26 am
Viewing 15 posts - 121 through 135 (of 145 total)