Viewing 15 posts - 5,611 through 5,625 (of 8,753 total)
SQLHeap (4/15/2015)
I don't want to start anything, just trying to get info. I'd like to stay with a SQL query.
without any parameters it only lists the services, should be...
April 15, 2015 at 11:05 am
Quick thought, how about cmd net start and parse the output?
😎
April 15, 2015 at 10:23 am
Zeal-DBA (4/14/2015)
my update query updating approx 50 million record which is causing transaction log to grow, and filling disk space and finally transaction is failing, please suggestany worl around.
Further on...
April 14, 2015 at 10:58 pm
Sean Lange (4/14/2015)
Eirikur Eiriksson (4/14/2015)
ztoddw (4/14/2015)
declare @STRING varchar(1000);set @STRING='100010111100010001';
select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))
from (select n=number, sub=substring(@STRING,number,len(@STRING))
from master.dbo.spt_values where type='P'
and (number between 1 and len(@STRING))) t
where...
April 14, 2015 at 3:34 pm
Revenant (4/14/2015)
djj (4/14/2015)
Eirikur Eiriksson (4/14/2015)
Ed Wagner (4/14/2015)
crookj (4/14/2015)
ChainsawFirewood
Soot
Clean
Break
Even
April 14, 2015 at 1:00 pm
Further on the install, I've had no problems installing 2012 alongside existing 2014 unlike previous versions.
😎
April 14, 2015 at 11:17 am
jay-h (4/14/2015)
Eric M Russell (4/14/2015)
syoc (4/14/2015)
April 14, 2015 at 11:11 am
ztoddw (4/14/2015)
declare @STRING varchar(1000);set @STRING='100010111100010001';
select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))
from (select n=number, sub=substring(@STRING,number,len(@STRING))
from master.dbo.spt_values where type='P'
and (number between 1 and len(@STRING))) t
where (n=1 or substring(@STRING,n-1,1)<>'0')
and...
April 14, 2015 at 10:42 am
geoforu (4/14/2015)
I was using sql server 2014 trial version. We bought sql server 2012 now.
How can we setup sql server 2012 ?
Will...
April 14, 2015 at 10:37 am
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.
Did you mean 0x3A99?
😎
April 14, 2015 at 8:57 am
Ed Wagner (4/14/2015)
crookj (4/14/2015)
ChainsawFirewood
Soot
April 14, 2015 at 8:27 am
Yet Another DBA (4/14/2015)
Eirikur Eiriksson (4/13/2015)
..... A good Kensington Lock Kit costs around $20, interesting to see a raise of hands here, how many use those regularly?....
Do you really think...
April 14, 2015 at 2:31 am
Luis Cazares (4/13/2015)
cooljagadeesh (4/13/2015)
thanks bossDo you understand the solution that Eirikur provided? There's at least one question that I'd ask.
Don't be shy Luis, you can ask:-D
😎
April 14, 2015 at 1:46 am
Viewing 15 posts - 5,611 through 5,625 (of 8,753 total)