Viewing 15 posts - 1,921 through 1,935 (of 5,394 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...
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.
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...
February 10, 2012 at 7:37 am
I don't get it.
Did you read the article I mentioned?
Code, please.
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...
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...
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...
February 10, 2012 at 4:32 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.
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?
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...
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
...
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...
February 10, 2012 at 2:15 am
Viewing 15 posts - 1,921 through 1,935 (of 5,394 total)