Viewing 15 posts - 76 through 90 (of 667 total)
Hehe,
I'm born Flemish, in other words Belgian. There the lower case 'v' in 'Van' means you've got some royal blood somewhere, maybe generations ago. So I'm obviously not in that...
June 19, 2013 at 10:11 am
I especially (dis)like the
11. Create View [TC_OPERate] As Select * From DLMESQLCLUSPROD.CORE.dbo.OPERate.
There are a few more of these.
June 19, 2013 at 9:55 am
onixsoft (6/19/2013)
Yes, I think it will be 2 options: use "smart" first name matching or by last name only
Even last name won't be accurate. My surname is sometimes spelled in...
June 19, 2013 at 9:46 am
crmitchell (6/19/2013)
...the Scottish variant is Iain - both are legal names.
My apologies 😉
June 19, 2013 at 9:33 am
Stefan Krzywicki (6/19/2013)
June 19, 2013 at 8:47 am
Sean is absolutely right. Have a read through Tom Thomson's excellent series on this site around Normal Forms starting right here[/url]. Then read the follow-up articles on Second and Third...
June 18, 2013 at 6:15 pm
And your own name, Alex, lends itself to the same exercise 🙂 (BTW, my oldest son's name is also Alex).
June 18, 2013 at 5:52 pm
May I humbly ask why you want to do this in the first place? My first name is Jan, which is both Dutch, Afrikaans and Polish (and probably exists in...
June 18, 2013 at 5:49 pm
Remember, the query optimizer looks for a verbatimly equal query in the plan cache and will use that if it finds one. Your replacing CRs and LFs changes the query,...
June 18, 2013 at 5:08 pm
There's nothing wrong in the CreateProcessTable script, in fact you wouldn't be able to do this in any different way anyhow. Building the column list in the LoadProcessFromTarget script will...
June 18, 2013 at 4:50 pm
Your problem is that you are adding the number of weeks to the base date of zero (1 January 1900), which happened to be a Monday. Changing your queries to...
June 18, 2013 at 4:07 pm
Well, I'm still not sure whether I understood your requirements correctly, and guessing this is not an exam question (they don't usually get that comlicated) let's give it a bash,...
June 17, 2013 at 12:15 pm
Yes, that's a good effort. However, from that test data I can really not see how you would get to the desired results. Could you please explain the algorithm behind...
June 17, 2013 at 7:14 am
No problem. Glad to hear Wolfgang's query does the thing you want it to do. Just a few more issues. Do your time intervals ever run past midnight? Or is...
June 16, 2013 at 5:01 am
No, it is certainly not the right way to do this. What you should do is take LOG backups every now or so often in between your full backups. Depending...
June 16, 2013 at 4:43 am
Viewing 15 posts - 76 through 90 (of 667 total)