Viewing 15 posts - 1,456 through 1,470 (of 2,462 total)
Arjun Sivadasan (8/13/2010)
1. Do I create PK before or after the insert (or if it depends, what are the factors)?
well it depends , sorting willbe done in either of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 6:22 am
appple (8/11/2010)
before rebuild on my index, framentation percentage is 80%,
after rebuilding indxes it is showing me same percentage,
Can Please Suggest me on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 5:57 am
Reading books : storing data in table variables
small practice : storing data in temp table
lots of practice: storing data in physical table
daily a...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 5:55 am
SureshS_DBA (8/13/2010)
the inputBuffer gives just the last transaction for that spid. As i metioned, If I ran another statement in same sesin, where I opened transaction, then it will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 5:41 am
Read this Multiple Instances of SQL Server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 5:33 am
Post the Sp you are using for deletion along with related index/table definfiton.
Additionally, you can use "batch approach" to delete the heavy data volume.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 4:53 am
try this ---------------------------------------------
-- Script to get file sizes from SQL Database
-- Script by Gareth Thompson (2010/08/06)
-- Tested on SQL 2005 and 2008.
---------------------------------------------
SET QUOTED_IDENTIFIER OFF
SET NOCOUNT ON
DECLARE @dbname varchar(50)
declare @string varchar(250)
set...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 4:46 am
that area(sp.script/job) will get failed where you have hardcoded the password
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 4:37 am
this can give you
declare @spid int
select @spid = spid from sys.sysprocesses where open_tran = 1
dbcc inputbuffer(@spid)
but it needs to be executed ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 4:36 am
CELKO (8/11/2010)
You might want to look at the Nested Sets model for this. Life will be better.
Any example or link ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 9:41 pm
CELKO (8/11/2010)
You really don't understand SQL yet and you keep posting the wrong kind of questions.
Yes i accept that i am not good in Sql but this is the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 9:38 pm
Post the table defintion/index defintion and sample data along with desired sample output.
See how to post queries article from my signature:-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 4:40 am
you can also use profiler to see where things are being holding up
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 4:37 am
ekknaveen (8/11/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 3:52 am
is there any sql script or stored proc running under it ? POst it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 1:24 am
Viewing 15 posts - 1,456 through 1,470 (of 2,462 total)