Viewing 15 posts - 1 through 15 (of 161 total)
Thanks for the response....it turns out the devil was in the detail and the sql server versions were not exactly the same. One was RTM and the other SP1. I've...
October 27, 2014 at 10:16 am
Does this do what you need...
(SUM(b.homescore) + SUM(c.awayscore)) as High_Score
FROM teams a
INNER JOIN results b ON
a.tnum = b.hometeam
INNER JOIN results c ON
a.tnum = c.awayteam
GROUP BY tname,country
HAVING (SUM(b.homescore) + SUM(c.awayscore)) >...
June 2, 2014 at 2:30 am
Ah right I see. I thought if the transactions had not been distributed to the subscriber (via the distributor) then they wouldn't. But that's not the case. You're saying that...
May 22, 2014 at 5:56 am
Have you run the likes of perfmon and SQL Profiler etc to see what happens on the box before and during startup of your application? This should give you a...
May 22, 2014 at 3:58 am
If you're using transactional replication, the log file for the publishing database will probably grow too as the VLFs inside that log file won't be marked as inactive (and therefore...
May 22, 2014 at 3:49 am
You can expand the [process] tab in Activity Monitor and that should show you. Alternatively you can run the following script (or the many variations of it) to query the...
March 26, 2014 at 11:04 am
Thanks for the reply. Right I get that, so PerfMon is sampling every second and showing the difference (in this case = 0), whereas SQL server DMV is showing the...
December 13, 2013 at 3:01 am
Well I tried that (from the blog post), fascinating. First method fine, stop service and delete log file etc. Second method (detach - delete - create new database and rename...
August 8, 2013 at 6:49 am
Thanks for that Gail. I'll check that post now.
Yes I totally agree RE: DR plan, we do have a proper DR plan for our prod/dev servers (inc full db and...
August 6, 2013 at 9:47 am
Gail that worked a charm. I followed the steps you outlined:
Identify Page (using DBCC IND)
Took DB offline
Opened MDF in HxD and navigated to page(offset)
Added some garbage text and save
July 2, 2013 at 8:39 am
Thanks guys...two different approaches. I'll try and have a go at each and post back my success rate.
Again, thanks 🙂
June 26, 2013 at 6:41 am
Yes, I like that idea. Haha
Thanks both for your time. I think I can work with that.
March 1, 2013 at 9:34 am
Thanks for the heads up. Unfortunately this is not our own XML, it's comes to us from a 3rd party and we have no control over the structure. Ideally it...
March 1, 2013 at 7:37 am
Hi, thanks for taking time to look at that. Ideally I'd like to see....
Emp_id Skill_ID Skill_Name
1 1 tSQL
1 2 SSRS
1 3 SSAS
1 4 SSIS
1 5 Replication
2 1 tSQL
2 2 SSRS
March 1, 2013 at 7:23 am
GSquared, that's perfect. It is a field in a table storing XML, not a single XML doc that I'm working with. That probably would have been my next question,...
December 11, 2012 at 9:32 am