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))...

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...

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

'.....

...

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...

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...

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...

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/

Indeed, you'll have to test it anyway 😀

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...

And this is soon:

Here is Cumulative update 1: support.microsoft.com/kb/2464079

Brent Ozar did a very good job highlighting the goals:

http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail/?utm_source=dlvr.it&utm_medium=twitter&utm_campaign=0810#

First make sure, your goal matches that of the software users managers.

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...

WayneS (12/21/2010)

---

ALZDBA (12/20/2010)

---

Apparently, on a side by side client install it breaks SQL2008 SSMS project stuff.

- New project on a new folder generates "creating project failed"

- opening an existing sql2008...

Just put the reply stewartc-708166 provided within at...

pavargasq (12/21/2010)

---

good afternoon

i have a question

usually processes,likE DTS, or procedures are run in the application server NAMED ie SERVER1, USING REMOTE DESKTOP AND RUN THE PROCESSES USING SSMO.

SSMO is also...