We might need a new forum for this technology! Ive taken on a new sql2008 client who is encountering some recent performance problems, Mostly the...
Switched partitions dont support replication but are they supported on mirrored databases, im guessing not but would like a definitive answer ?
I have a sql2008 reports server running on win 2003 and sql server 2008 (sp1) and a development machine running windows 7. I cant deploy reports...
When a sql 2005 database has a shared folder icon in studio what is it indicating ? is this an indication db mirror is enabled ? Colin
Any one now how to create a percent of total column with areport builder report, or as a calculated value in the model? I can manage it in a normal...
Anyone got any pointers/comments to replicating databases with full text indexing enabled. Does each server need to maintain its own Full text index...
The following script creates and starts a trace for long running sql on our server with a max of 5 20mb rollover files, however if the server has...
Checking identity information: current identity value '270000', current column value '272382'. DBCC execution completed. If DBCC printed error...
we have two VM Environments and 4 Enterprise 2005 Licenses purchased in Jan before ms changes to virtual licensing in June. can we assume the June...
Im attempting to load test a peer 2 peer replication using sql2005 enterprise and thought I could trace a production day using profiler and replay...
is there a method to estimate how long index creation will take on very large tables. (in most cases the index would be complete before the calc was...
Im a great fan of Red-gates Product Line but sql compare wont yet create difference scripts with replication dependancies like not dropping objects...
slq server 2005 build 3042 Our Db grew from 50GB to 200Gb overnight. It turned out that the cause was some weird behavior from the SSIS rebuild...
SQL 2005: This one should be easy, How do you stop profiler from doing this when tracing date values. (ive accepted this to date but now I need to...
Sql2005 server running on vmware. We have an intermittent performance problem on our virtual server CPU suddenly jumps from its normal 25% to 75% at...
Vista sp1 installed overnight on my laptop which was running sql2005 & analysis services, Reporting services etc with no problems. After sp1 reboot...
Does anyone have a link to SSRS versions of the performance dashboard reports. or is it as simple as publishing the rdls to your rs server and...
I was reading several posts on the web that suggested you need to retain side by side install of visual studio 2005 to retain your BI projects like...
Are they still using old mapi mail and need a profile, or are they using the newer DBMAIL functionality? Im not getting the mail alerts and wondering...
Our production sql servers are licensed under volume licensing arrangements. Our dev team is currently licensed under msdn subscriptions each...
Separate names with a comma.
