Viewing 15 posts - 856 through 870 (of 2,462 total)
Why you have used here where 1=1
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 3:26 am
poratips (11/6/2012)
I have another situation that my developer wants some tables from Prodction DB server to their desktop m/c.
We have already sql express installed and Database and tables...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 1:09 am
poratips (11/4/2012)
Thanks Jeff.When i do again Database Refresh on a By Weekly or Monthly, so i need to follow the same steps or is it any other approach or method?
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 4:00 am
Any index on FiledDate OR FieldDescr column ? if not then create tow separate indexes.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 3:21 am
Saravanan_tvr (11/4/2012)
Most of the MS prodcuts are keeping [uniqueidentifier] as primary keyPlease let me know, what motives is in?
just for security prospects .. so that nobody can identify...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 3:16 am
arnipetursson (11/1/2012)
Since you are going to 2008, you should be using backup compression by default.
i read somewhere that compressed backups take cmparatively high CPU (from normal backup files) during...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 3:05 am
what exactly do you mean by syncing ? drop and then create on destination side ?
additionally here u need to do some brick work to create some script which will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 1:00 am
harri.reddy (11/2/2012)
when i am using ssis package ,its gives me error
Paste the error here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 12:46 am
declare @a int=1
declare @lsql nvarchar(300)
set @lsql = ''
while @a<2056
begin
set @lsql = ''
set @lsql = 'create nonclustered index testindex_' + cast (@a as...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 12:29 am
mohsen.bahrzadeh (11/5/2012)
i want paging result data but i dont know how to do paging.please help me. thanks all.
What exactly do you want here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2012 at 12:19 am
vinu512 (10/19/2012)
So, please guys.....any other suggestions of how I could get this to work??
for the time begin you can test the SSIS package manually . see if it get blocking...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 26, 2012 at 9:21 am
GilaMonster (10/26/2012)
That's doubly wrong, because EXISTS with correlated subqueries does not perform equally with joins, it's usually very, very slightly better (and actually they're not even equivalent query forms)
Good learning...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 26, 2012 at 9:01 am
Raymond van Laake (10/26/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 26, 2012 at 8:52 am
set the profiler trace see if it helps
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 26, 2012 at 1:26 am
Mischa E.J. Hoogendoorn (10/25/2012)
I just do not understand why the test message is sending correctly when these options are not set...
i stil dont believe this , if the mail...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 4:40 am
Viewing 15 posts - 856 through 870 (of 2,462 total)