Viewing 15 posts - 2,026 through 2,040 (of 7,499 total)
linq usage doesn't need to be less secure !
Using linq as an excuse for open doors is the summum of laziness
some refs on using sprocs with linq:
http://www.mssqltips.com/tip.asp?tip=1542
http://blogs.msdn.com/b/zainnab/archive/2007/10/25/linq-and-stored-procedures.aspx
http://msdn.microsoft.com/en-us/magazine/cc500645.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 28, 2011 at 3:32 am
GilaMonster (5/27/2011)
Elliott Whitlow (5/26/2011)
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 27, 2011 at 2:17 am
You clould find some info on the web, but I propose to just capture the full xml to investigate the availability of data and then have a look at bol...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 26, 2011 at 1:18 pm
- consider an "on delete" trigger to perform your insert into tableB
- On insert in tableA, you could also use an "insert" trigger to fetch the available missing data from...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 26, 2011 at 1:13 pm
I haven't performed such an action (edition upgrade) from 2005 to 2008 myself but
wouldn't such an action need a setup from the commandline using /ACTION=editionupgrade ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 23, 2011 at 2:31 pm
Just some feedback ...
I use 2 clocks ( mainly for myself ! ):
1) single beep notification: to drink a bit of water. Prevention measure no1.
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 23, 2011 at 1:13 am
.... After upgrade the the database still shows version 9. ...
Must have confused me.
Did the upgrade succeed or didn't it ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 23, 2011 at 12:45 am
I've seen the same behaviour.
You'll have to alter the dblevel yourself if desired (even for system db)
That's one of the reasons why I don't upgrade an instance, but prefer...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 22, 2011 at 1:17 pm
george sibbald (5/20/2011)
On the other hand you would have to have sperate disk resources for the new...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2011 at 9:24 am
John Mitchell-245523 (5/20/2011)
ALZDBA (5/20/2011)
I had the impressions that would only be the case in active/active setups
You're quite right - I said active-passive but I meant to say active-active. I'll...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2011 at 6:22 am
colin.Leversuch-Roberts (5/20/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2011 at 6:00 am
John Mitchell-245523 (5/20/2011)
Be aware that if you go active-passive then your licensing costs double, since you have to pay for a licence for each node that SQL Server runs on.John
I...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2011 at 5:54 am
concerning the number of active connections ... that is not a problem because you'll have to stop and restart the sqlinstance anyway to actually have it using your tempdb files...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2011 at 12:04 am
Mind me asking why would you want to your instance to be in single user mode ?
Couldn't a user db in restricted user mode serve you well enough ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 19, 2011 at 2:26 pm
This is what I would propose:
As last step of your JobA just run a ISQL script connecting to your ServerB and raising an alert at that sql instance and have...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 19, 2011 at 11:43 am
Viewing 15 posts - 2,026 through 2,040 (of 7,499 total)