Viewing 15 posts - 166 through 180 (of 1,192 total)
Ha, yeah my bad. My cranial £ to $ rate is faulty!
May 13, 2015 at 10:36 am
From MS's point of view: 2-core VM with Enteprise Edition ~$4000. 10 x Dev Editions ~$500. Think I know which one they prefer 😀
May 13, 2015 at 7:59 am
Are the videos individual files on the array?
May 13, 2015 at 7:35 am
(I'm assuming it's all 64-bit rather than 32-bit).
If you've got Sharepoint, SQL & SSRS all on the same box& only 8GB RAM there's likely to be all sorts of memory...
May 12, 2015 at 3:43 am
Sean Lange (5/7/2015)
gwyn.jones (5/7/2015)
I am adapting old code, hence the numerous substrings - I...
May 7, 2015 at 7:37 am
Period seems to have become customer_order_no in your code 🙂
Try casting to datetime or date first:
convert(varchar(10),cast(substring(m.customer_order_no,1,2)+ '/' +substring(m.customer_order_no,4,2)+ '/' +substring(m.customer_order_no,7,2) as date),103) as 'start_date'
Is this not easier though?:
CONVERT(VARCHAR(10), CAST(LEFT(m.customer_order_no, 8)...
May 7, 2015 at 7:18 am
Great question & thanks for the links.
Found this interesting in the Non-Foldable list on the MSDN page:
Expressions whose results depend on a local variable or parameter
Which casts a whole...
April 23, 2015 at 2:53 am
spaghettidba (4/20/2015)
GilaMonster (4/20/2015)
Jeff Moden (4/20/2015)
GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.Awesome!
Not usually. 🙂
It's one reason why the default trace sometimes covers such a short time...
April 21, 2015 at 7:07 am
Koen Verbeeck (4/21/2015)
Jeff Moden (4/19/2015)
Excellent. And help that young fellow learn how to wear asbestos underwear when everyone is trying to burn him at the stake.
You try to burn...
April 21, 2015 at 5:19 am
Does this work?
select
[Location_Code] AS 'Location Code'
,[Gt 0-1], [Gt 1-2], [Gt 2-3], [Gt 3-4]
,[Gt 0-1] + [Gt 1-2] + [Gt 2-3] + [Gt 3-4] AS Total
from ...
or
select 'Location Code', [Gt 0-1],...
March 11, 2015 at 12:07 pm
If it's not there then as Gail & JM said it probably happened before the oldest record in the trace, and you won't be able to find it.
March 11, 2015 at 11:55 am
river1 (3/11/2015)
But non with the object name , just the object id.
But if the object was deleted (droped) how can I know it's name...
March 11, 2015 at 6:16 am
river1 (3/11/2015)
The default trace can be read from inside the sql server? do I have any function to read it?
sys.fn_trace_getinfo & fn_trace_gettable
Something like this:
declare @file nvarchar(1000);
SELECT @file = cast(value as...
March 11, 2015 at 5:31 am
Viewing 15 posts - 166 through 180 (of 1,192 total)