Viewing 15 posts - 541 through 555 (of 2,462 total)
Nikhil welcome to SSC. friend 🙂 we need something to tell you something. means post the table defintion along with some sample data , also expected output based on sample...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 1:24 am
why so much of data on excel .it would be difficult to analyze it there (difficult to slice and dice) or even to scroll.
from excel too , you can do...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 1:19 am
some on instance level ....some database level..some table level.
better google it 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 1:14 am
use databasename
go
select * from sys.sysfiles
go
select * from sys.database_files
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 1:12 am
jitender, are you still experiencing same memory issues ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 12:17 am
ScottPletcher (1/9/2013)
the cursor should be optimized with FAST_FORWARD:
Any article reference for this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 11:36 pm
paul 77096 (1/9/2013)
Thats Brilliant, it worked like a dream.
in future try to avoid cursors instead use loop or set based approach. why ???? google it 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 4:44 am
Thanks gail for explanation..
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 4:42 am
try this in your cursor code
DECLARE @sql NVARCHAR(4000);
While
begin
SET NOCOUNT ON
SET @sql = 'CREATE LOGIN ' + @username + ' WITH PASSWORD = ''12345'', DEFAULT_DATABASE=[dbname], DEFAULT_LANGUAGE=[British], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON';
EXECUTE(@SQL);
exec...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 4:24 am
thanks gail
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 3:06 am
julian.fletcher (1/9/2013)
Really? Do you have any links to further details? That would be very helpful.
sse this link http://sqlserverplanet.com/optimization/using-union-instead-of-or
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 3:00 am
its happening because of OR usage in first query , yes it is well know performance glitch.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 1:21 am
hi2u (1/8/2013)
Sometimes i get the following error on usp_Table1"Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in onject 'dbo.Table1'
i am not agree you will get this error...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 1:18 am
kevin_nikolai (1/8/2013)
Both a trigger and cdc (change data capture) can be enabled to monitor changes to a table.When would you use each of them, which is best ?
see...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 12:57 am
another query
select name,[Phone],[Sms],[Email]
from
(
select name , mode , sum(case
when name = 'AAAAA' then 1
when name = 'BBBBB' then 1
when name = 'CCCCC' then 1...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 12:47 am
Viewing 15 posts - 541 through 555 (of 2,462 total)