Viewing 15 posts - 91 through 105 (of 123 total)
An interesting debate.
I've put together a function in pure T-SQL which would do the same job. I doubt this would perform as well as opc's code, but hey it's another...
June 29, 2011 at 2:56 am
Same here, I confidently clicked "No" and was shocked to be told "Yes"!
Further shock ensued when I read the explanation and the "No" answer was confirmed...
Mike.
June 29, 2011 at 2:23 am
James
You would expect an MCM to be able to handle pretty much anything you throw at them, but I think Jeff is right - a qualification doesn't necessarily prove you...
June 23, 2011 at 2:17 am
When I've interviewed people, I've presented them with a brief overview of a problem, which I then ask them to create a database design from (normalised or not - I'm...
June 22, 2011 at 3:41 pm
You do not necessarily need 6-12 months experience to pass the exam (though it would definitely help!).
Follow the study guide for the exam you are interested in and practice, practice,...
June 20, 2011 at 5:13 am
Please don't bother with the dumps - you are short-changing yourself and everybody else who takes the exams.
If you want some sample questions visit Transcender[/url] and Pass Guaranteed. Download the...
June 20, 2011 at 5:11 am
I learnt SQL Server programming using Robert Vieira's Programming SQL Server 2000 book. It's a great book and very comprehensive.
The 2005 version is also excellent but contains a number of...
June 20, 2011 at 5:05 am
I have to agree with everybody else - give yourself some background in administration and development first. You'll find BI relatively straightforward if you are armed with some background knowledge.
If...
June 17, 2011 at 4:26 am
Cheers Gail, I realise that on reading the responses properly.
That's the last time I scan something and respond whilst I'm on a conference call...
Mike.
June 17, 2011 at 3:39 am
Hi guys
You are right - my bad. Sorry everybody!
Mike.
June 17, 2011 at 3:10 am
Hi
I've used SQL Server on both VMWare and Hyper-V, and both were comparable in my experience.
Brent Ozar is definitely the man to read regarding virtualisation. He gave a good tip...
June 17, 2011 at 2:39 am
Hammad
Another way to answer your original question is to use database snapshots, which makes the process a bit easier. A snapshot is a read-only copy of the database at the...
June 17, 2011 at 2:28 am
Hi Laerte
It does sound as though your mirroring configuration is fine. Daft as it sounds, try doing a refresh of the tables in SSMS. This will probably fix the issue...
June 17, 2011 at 2:23 am
To throw in my two cents worth (or should that be pence - I'm British)...
Lowell was spot on when he/she said "it depends".
In general I would recommend separate sprocs for...
June 16, 2011 at 2:48 am
Thanks Paul.
Now the pressure is on...!
Good luck to Rich too.
Mike.
June 15, 2011 at 2:04 pm
Viewing 15 posts - 91 through 105 (of 123 total)