Viewing 15 posts - 20,251 through 20,265 (of 59,072 total)
I've actually had the phenomena occur in my truck overnight in the winter months both with bottled spring water and Pepsi. It's amazing how cold it was (~10o-15oF) and...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 9:00 am
cstg85 (6/23/2015)
Your post couldn't have come in a more timely manner, the time calculation is actually apart of a bigger query which in fact returned the error you mentioned....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 8:46 am
True enough but if SQL Server can see the file, so can the DBA... and he doesn't even need to use xp_CmdShell to do it. When I say "see"...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 8:17 am
Yep... Saw that. You'd be better off partitioning by year.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 8:15 am
RTaylor2208 (6/23/2015)
The rest was me...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:47 am
I've never seen such problems as you mention with SELECT/INTO Leo but that doesn't mean they don't exist. Thanks for the warning.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:39 am
JManuelN (6/23/2015)
One option could be enabling security audit (if the SQL Server edition allows it) and set the log file to a protected folder with no write permissions for sysadmin...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:36 am
I haven't tried that code but it looks right. Heh... I definitely recognize the "workday" code.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:32 am
Actually, DBA from the Cold provided a pretty good summary for you to easily follow. I'm not begging off but my presentation material is a whole lot more complicated...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:31 am
I'd do RANGE RIGHT because it seems to be the method that humans understand where the partition date is the first date of the partition rather than the last.
I have...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2015 at 7:04 am
mw112009 (6/22/2015)
This is very slowUpdate #acrc
Set sbp_mbp = [RESEARCH].[dbo].[determine_num_of_mins_exceed_5_where_SBP_MAP_is_less_than_a_certain_value](Case_ID);
However if I do a
Select @sbp_mbp= [RESEARCH].[dbo].[determine_num_of_mins_exceed_5_where_SBP_MAP_is_less_than_a_certain_value]('12345');
--This gets executed within a few seconds
Gail and the others are correct. If you...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 22, 2015 at 10:54 pm
bgalway (6/22/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 22, 2015 at 9:58 pm
To be absolutely honest, the table has only about 25 million rows in it and, unless it's a very wide table or unless it has some massive data stored in...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 22, 2015 at 9:53 pm
SandyTucker (6/22/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 22, 2015 at 6:30 pm
SandyTucker (6/22/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 22, 2015 at 6:20 pm
Viewing 15 posts - 20,251 through 20,265 (of 59,072 total)