Viewing 15 posts - 3,826 through 3,840 (of 18,926 total)
Yup, waiting for ddl and sample data to GIVE YOU the tested solution.
You guys have been turning round and round for long enough, it's time for tested code.
August 3, 2011 at 7:10 am
No other idea for this one... stepping aside.
August 3, 2011 at 6:53 am
pwalter83 (8/3/2011)
Welsh Corgi (8/3/2011)
Do you know what DDL and sample data is?
No actually my English is not good neither are my SQL skills...I do know what a stored procedure is...
August 3, 2011 at 6:51 am
And I was lazily replying to 2 comments at the same time. 😀
I knew YOU know that Jeff, but that truth is easy to miss like the forest for the...
August 3, 2011 at 6:38 am
What do yo mean that get 5 GB out of it?
SS does what you ask it to. If you say put a 5 GB log file there, it'll do just...
August 3, 2011 at 6:37 am
Are you using sps or selects in datasets? Or maybe both?
August 3, 2011 at 6:35 am
Your group by is wrong. It's stopping the MAX from bringing it all to 1 row.
August 3, 2011 at 6:31 am
chandan_jha18 (8/3/2011)
sehgalnamit (8/3/2011)
Can we shrink the database files while restoring from backup?
First find out why you need to shrink:
1) If you see that there is a lot of space left...
August 3, 2011 at 6:25 am
crazy4sql (8/3/2011)
sehgalnamit (8/3/2011)
Can we shrink the database files while restoring from backup?why not shrink before taking backup.
PS:- Shrink should be avoided for day to day operation.
Should ALWAYS be avoided unless...
August 3, 2011 at 6:21 am
Install on a test server. Make sure the app still works.
BACKUP EVERYTHING, inclusing system dbs.
Apply latest, test SPx
Retest application.
If something went wrong you basically have to rebuild the server...
August 3, 2011 at 6:18 am
Ya but you can format the date to whatever you want once in ASPX. I would search there rather than SQL side.
August 3, 2011 at 6:12 am
chris.davidson (8/3/2011)
Ninja's_RGR'us (8/2/2011)
For this reason :...
August 3, 2011 at 6:04 am
Viewing 15 posts - 3,826 through 3,840 (of 18,926 total)