Viewing 15 posts - 1,921 through 1,935 (of 5,393 total)
Jack Corbett (2/10/2012)
Kevin Kline has some excellent blog posts/presentations about meetings that you should check out. I think he did one for the first 24hop that was...
-- Gianluca Sartori
February 11, 2012 at 2:45 pm
Steve Jones - SSC Editor (2/10/2012)
Worth the read: http://www.newyorker.com/reporting/2011/10/03/111003fa_fact_gawande
A great read. Thought-provoking and very well written.
Thanks for sharing.
-- Gianluca Sartori
February 11, 2012 at 2:39 pm
shahid_jambagi (2/9/2012)
nope the server name is showing as administrator not the domain user. do i need to login as domain user.
So, where's the problem? Log off, log in as domain...
-- Gianluca Sartori
February 10, 2012 at 7:37 am
I don't get it.
Did you read the article I mentioned?
Code, please.
-- Gianluca Sartori
February 10, 2012 at 6:39 am
neil-560592 (2/10/2012)
What else, apart from the number, determines how SQL Server chooses its deadlock victim?
Basically SQL Server looks for the process that would be easier to roll back. This often...
-- Gianluca Sartori
February 10, 2012 at 6:07 am
I don't understand exactly what you're after.
Can you post an example with some sample data and the destination table definition?
Read the article linked in my signature line and you will...
-- Gianluca Sartori
February 10, 2012 at 6:01 am
I see dynamic SQL as the only way to go.
Turn the whole T-SQL statement to a nvarchar(max) variable and execute it with sp_executesql.
Example:
DECLARE @tableName sysname
SELECT @tableName = 'master.dbo.spt_values'
DECLARE @sql nvarchar(max)
SET...
-- Gianluca Sartori
February 10, 2012 at 4:32 am
And the question is?
-- Gianluca Sartori
February 10, 2012 at 4:22 am
Assign a default to the second parameter in case it is not passed.
There's not much you can do about it, other than that.
-- Gianluca Sartori
February 10, 2012 at 3:52 am
A scalar UDF in this context would be a performance nightmare. I would avoid it like the plague.
Why not use a view instead?
-- Gianluca Sartori
February 10, 2012 at 3:50 am
Anamika (2/10/2012)
in this case will i be able to find the cause by opentran? how is there any other to way to find out why the tempDB is growing?
Schedule the...
-- Gianluca Sartori
February 10, 2012 at 3:46 am
ALTER TRIGGER [dbo].[linecbm] ON [dbo].[SALES_ORDER_LINE]
AFTER UPDATE
AS
BEGIN
IF UPDATE (DRAWING_REV_NO)
UPDATEmt
SETmt.HEIGHT =
CASE
...
-- Gianluca Sartori
February 10, 2012 at 3:43 am
Anamika (2/9/2012)
tempDB is not stored in C:
Fine. Good to hear that.
my question is is there any connectivity between C: is not having enough space, and because of this the tempDB...
-- Gianluca Sartori
February 10, 2012 at 2:15 am
Viewing 15 posts - 1,921 through 1,935 (of 5,393 total)