Viewing 15 posts - 1 through 15 (of 55 total)
Does hardware performance of the machine are the same?
make rebild indexes and update statistics
June 24, 2015 at 7:28 am
try using exec master.dbo.xp_fixeddrives,
when you get all disk on given server, you can use sp_OAGetProperty for get TotalSize and FreeSpace.
@tSize = sp_OAGetProperty @disc,'TotalSize', @resTS output
@fSize...
May 15, 2015 at 1:28 am
log in with your Administrator,
that is user specified when you installed sql server.
If you forgot the pass and user name then read about recovery SA password
April 29, 2014 at 2:23 am
try this
declare @test-2 varchar(1000)
declare @rez int
set @test-2 = 'alksjdfhkalsdhf update a;slkfjdlakjsdf where sadlkfjak!sdlfj people_table asdjfadsf'
if ( charindex('update',substring( @test-2, 0, charindex('where',@test,0) ))...
March 26, 2014 at 5:35 am
did you check status of SA user on linked server?
March 6, 2014 at 6:39 am
everything is float representation
if you won't be able to change definition of table
just change query
select A.ID, B.ID, A.Value, B.Value
FROM #TestAA A
INNER JOIN #TestBB B ON A.ID = B.ID
WHERE cast(...
February 13, 2014 at 4:55 am
i would mention something here,
be cautious when you work with real number, because there is a little bit difference in result when you sum float, decimal or money data type.
In...
February 12, 2014 at 10:05 am
check this sql statement.
select * from sysmail_mailitems
go
select * from sysmail_log
go
select * from sysmail_sentitems
go
select * from sysmail_allitems
go
select * from sysmail_event_log
if there isn't any problem, maybe there is problem with group...
February 6, 2014 at 5:15 am
hoseam (2/6/2014)
I want to create a new table with the about of that query, that output has to be my columns
maybe
select NOTE_ID, NOTE_DESCRIPTION, NOTE_TEXT, NOTE_STATUS, NOTE_STARTDATE
, NOTE_ENDDATE, NOTE_AUTHOR, NOTE_LASTUPDATE...
February 6, 2014 at 3:43 am
there also be security concern for using CLR. You enable access to the .NET framework.
In that case you provides too many things and mechanisms on the system than sql by...
February 5, 2014 at 7:20 am
first execute this
exec sp_configure 'Ole Automation Procedures', 1; reconfigure with override;
then USED THIS CODE
declare @ipServer varchar(20) ='10.1.1.95'
if exists (select name FROM tempdb..sysobjects where name = '#disks')...
February 5, 2014 at 6:15 am
read something about parameter sniffing.
put your code if its possible
January 9, 2014 at 5:01 am
you can get table structure from procedure.
use this to get column from SP table
;WITH SP AS (
SELECT
o.name AS proc_name, oo.name AS table_name, oo.id, ooo.name,
ROW_NUMBER() OVER(partition by o.name,oo.name,oo.id,...
October 25, 2013 at 12:58 am
sending sms is not a feautre of sql server.
there are many opensource smpp client which is use for this purposes.
read about smpp protocol
October 25, 2013 at 12:46 am
declare @input varchar(50)='100,200,300,400,500'
select '1', q2.value from
( SELECT cast('<x>'+replace(@input,',','</x><x>')+'</x>' as xml) as txml ) q1 CROSS APPLY
( SELECT x.value('.','varchar(100)') as value FROM txml.nodes('x') as f(x) )q2
October 22, 2013 at 4:51 am
Viewing 15 posts - 1 through 15 (of 55 total)