Viewing 15 posts - 466 through 480 (of 2,463 total)
m.rajesh.uk (1/21/2013)
How to propose a monitoring Solution for a server..
can you provide more details ? What you have and what u need ?
the problem is the, other can't...
January 21, 2013 at 4:29 am
Tara-1044200 (1/17/2013)
January 21, 2013 at 4:14 am
see this
declare @t table (Ename nvarchar(200), EmpNo int)
insert into @t
select 'Bhuvnesh' , 11 union
select 'girth' , 11 union
select 'pooja' , 12 union
select 'rana' , 12...
January 21, 2013 at 3:26 am
Akkare (1/21/2013)
Can somebody differentiateBufferPool
VAS
Memtoleave
for buffer pool you can refer above link but for other google them , you will find a lots of article or links
January 21, 2013 at 3:09 am
m.rajesh.uk (1/21/2013)
How to Query Tune The Stored procedure.. Any helpful document..Where to start
how to do..
Thanks
VERY vast topic . one can spend months or even years on it.
a lots of...
January 21, 2013 at 2:27 am
shreekanth.kavali (1/20/2013)
pls give what are the regular issues often comes in sql server security,mean to say trouble shooting issues in sql server interms of security point of view
it seems like...
January 21, 2013 at 1:40 am
it will be easy for people if you post the table defifntion (create stmt) along with some sampoled data plus expected output.people generally steal some time from their busy scehdules...
January 21, 2013 at 1:38 am
it will be easy for people if you post the table defifntion (create stmt) along with some sampoled data plus expected output.people generally steal some time from their busy scehdules...
January 21, 2013 at 1:37 am
rajkiran.panchagiri (1/21/2013)
I need from which sql login that particular statement is running.
TRy this SELECT
‘SESSION_ID: ‘ + CAST(es.[session_id] AS VARCHAR(4)) + ‘ ‘ +
‘ HOST_NAME: ‘ + es.[host_name] + ‘ ‘...
January 21, 2013 at 1:28 am
getsimrangujral (1/21/2013)
I want to generate script for a table through command
see this linl http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/
January 21, 2013 at 1:25 am
this is the topis where aggressisevly , somebody can spend days , months or might be years but for start follow below links 😀
http://msdn.microsoft.com/en-us/library/aa337525(v=sql.105).aspx
http://support.microsoft.com/kb/321363/en-us
January 21, 2013 at 1:20 am
sej2008 (1/21/2013)
I want to understand since dml triggers are using data modification statementsare they logged in log file and if yes when?
i dont think they are differently/specially get treated...
January 21, 2013 at 1:15 am
sej2008 (1/21/2013)
and another is row level update trigger
from BOL
sql_statement
Is the trigger condition(s) and action(s). Trigger conditions specify additional criteria that determine whether the attempted DELETE, INSERT, or UPDATE...
January 21, 2013 at 1:12 am
getsimrangujral (1/21/2013)
generate script with large table ?? so i can run script in another database server
friend ,
The problem is "we cant see what you see", what you...
January 21, 2013 at 1:05 am
-- Execute the query inside target database
SELECT TOP 10
qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds,
qs.total_elapsed_time / 1000000.0...
January 21, 2013 at 12:56 am
Viewing 15 posts - 466 through 480 (of 2,463 total)