Viewing 15 posts - 2,521 through 2,535 (of 7,502 total)
If you have ssms on that server, can you just start it.
Do not connect to the server yet!
so cancel the connect popup.
Then click "new query" and then connect using the...
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
December 30, 2010 at 4:59 am
- please provide sql2005 version info ( @@version )
- is this an upgraded db (from 7 or 2000) ?
(and did you perform post migration maintenance ?)
- can you run dbcc...
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
December 30, 2010 at 4:51 am
1) why are you using 4-part naming ?
You should just connect to the correct sql-instance and db and use two part naming.
2) did you enable and configure msdtc at the...
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
December 30, 2010 at 4:45 am
What's wrong with:
/* day 2 of the current month 00:00:00.000 */
select dateadd(dd,1,dateadd(mm, datediff(mm, 0, getdate()), 0))
/* if you need day 2 12 noon */
select dateadd(hh,36,dateadd(mm, datediff(mm, 0, getdate()), 0))...
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
December 29, 2010 at 8:38 am
IMO aligned indexes provide both performance and recovery advantages:
- performance: because the are physically split like their corresponding table, so the engine will only use the part needed by the...
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
December 28, 2010 at 3:32 pm
you can use
return(@yourcode)
to provide an exit code for your sproc.
in your app you can capture this value using the first parameter @return_value.
e.g.
If sqlcmd.Parameters("@RETURN_VALUE").Value.ToString = "0" Then
'.....
...
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
December 28, 2010 at 3:21 pm
Please use the datetime data type when working with datetime info, so you don't have to bother about formating and have all wonderful datetime related functions available.
Have a look at...
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
December 28, 2010 at 12:42 pm
As Ray Mond stated, to restore a db, you'll need free space at least equal to the size of the database files at backup time.
If your bak file contains...
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
December 28, 2010 at 4:32 am
Be sure to start off with all columns you need in your data system.
e.g. maybe it's better to add birth date to your users table and calculate age yourself (inline...
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
December 27, 2010 at 8:16 am
just the refs of some interesting articles on data analysis (DA) and normalization:
http://www.sqlservercentral.com/blogs/abhijit_desai/archive/2010/09/07/noramlization.aspx
http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/
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
December 27, 2010 at 8:08 am
Indeed, you'll have to test it anyway 😀
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
December 26, 2010 at 10:27 am
Just a first thought.
Why is userid the pk of your fitnessdetails entity ?
Can a user only have a single fitness detail ?
IMO a user can change bodiweight and bmr over...
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
December 26, 2010 at 8:22 am
And this is soon:
Here is Cumulative update 1: support.microsoft.com/kb/2464079
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
December 26, 2010 at 12:11 am
Brent Ozar did a very good job highlighting the goals:
First make sure, your goal matches that of the software users managers.
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
December 23, 2010 at 1:28 pm
Had my first holidays day off today:
- already boiled an egg
- cooked rice, carrots and sausages
If I would project this experience to most companies IT level, I guess...
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
December 22, 2010 at 10:47 am
Viewing 15 posts - 2,521 through 2,535 (of 7,502 total)