Viewing 15 posts - 466 through 480 (of 2,462 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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 21, 2013 at 4:29 am
Tara-1044200 (1/17/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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] + ‘ ‘...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
http://support.microsoft.com/kb/319942/EN-US/#appliesto
http://support.microsoft.com/kb/316749/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 21, 2013 at 12:56 am
Viewing 15 posts - 466 through 480 (of 2,462 total)