Viewing 15 posts - 391 through 405 (of 2,462 total)
why cant we use "xp_fixeddrive" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 26, 2013 at 9:09 am
mpradeep23 (1/25/2013)
is thier any performance issue by creating tables and sp s in model database
No
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 5:11 am
surilds (1/25/2013)
It would be better if you have queries for past run queries?
i dont think it would be available everytime , it solely depends on plan cache.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 5:08 am
Minnu (1/25/2013)
if particular record is not there in that table, then it should not join that table, like that i want to compare 20 tables.
Why ? just to make...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 5:05 am
try this
SELECT
‘SESSION_ID: ‘ + CAST(es.[session_id] AS VARCHAR(4)) + ‘ ‘ +
‘ HOST_NAME: ‘ + es.[host_name] + ‘ ‘ +
‘ PROGRAM_NAME: ‘ + es.[program_name], ‘ ‘ + CHAR(13) + CHAR(10),
‘...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 4:59 am
Dave Hall (1/25/2013)
I'd love to Bhuvnesh but I'm using SQL 2000 🙁
oh my bad i just realized that i am in sql 2000 window :Whistling:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 3:30 am
Dave Hall (1/25/2013)
I'm calling the 1st Proc like before and the transaction errors are gone (yay) BUT the Delete statement still executes and is not rolled back (boo).
Then i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 3:24 am
Also see this link too http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 3:14 am
Instead , why cant you use SET XACT_ABORT ON in both the SP and remove all explicit transaction handling
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 3:10 am
padhu.mukku (1/24/2013)
Try to use Table variale
Depends.... if you are using heavy volumne data and you would be using same resultset in later part of SP too (in JOINs...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 12:16 am
usefull link http://msdn.microsoft.com/en-us/library/ms184246(v=sql.90).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 12:12 am
usefull link http://msdn.microsoft.com/en-us/library/ms184246(v=sql.90).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 12:11 am
deep.tkt (1/24/2013)
If we use rebuilding clustered indexes to move objects between data file what is impact where there is 100GB clustered index ?
there are couple of things yoou...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2013 at 12:09 am
arthi.anan (1/24/2013)
So when i login with 'empdbo', i'm able to access 'emptest' db. This should not be allowed.
'empdbo' will be sysadmin thats why it can access anything in that...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 11:49 pm
This document talks about replication and database mirroring (including information on trace flag 1448 which allows the log reader to replicate changes regardless of the mirroring state):
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2013 at 11:23 pm
Viewing 15 posts - 391 through 405 (of 2,462 total)