Viewing 15 posts - 31,621 through 31,635 (of 49,552 total)
Script it out (as a server-side trace), set the required variables, stick it in a SQL Agent job.
In profiler: File -> Export -> Script Trace Definition.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 27, 2010 at 7:02 am
Enable traceflag 1222. That will make the SQL engine write a deadlock graph into the error log every time a deadlock occurs. Post the deadlock graph and definitions of all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 27, 2010 at 4:30 am
balaji.ganga (7/27/2010)
Backup log databasename with truncate_only
Which breaks the log chain and leave you unable to take log backups or do point in time recovery until another full/diff backup is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 27, 2010 at 1:55 am
I think you're going to have to explain in more detail what it is you want to do here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 11:36 pm
SQL* (7/26/2010)
But the temp table will be created in temp database right,
Yes
then how the table dropped with out issuing a drop statement.
Because it was created within a transaction. When...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 11:35 pm
The Dixie Flatline (7/26/2010)
GilaMonster (7/26/2010)
Jack Corbett (7/26/2010)
Wow, Honeywell is hiring a database guy. Based on the databases I've seen behind Honeywell products you are the first.
That's not something I'd...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 3:07 pm
Jack Corbett (7/26/2010)
Wow, Honeywell is hiring a database guy. Based on the databases I've seen behind Honeywell products you are the first.
That's not something I'd like to hear about...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 2:48 pm
Lynn Pettis (7/26/2010)
Going to work for Honeywell. Government contracts, about all I can really say.
Sounds intriguing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 12:19 pm
Jeff Moden (7/26/2010)
BWAA-HAA!!!! Gotta love that... MS "supports" deadlocks. :-):-D:-P;-):hehe:
The Sharepoint team only.
Someone I know took this problem to customer support. The SQL support team looked over the logs,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 12:01 pm
Same as any other edition (other than express)
524 272 Terabytes
Doubt you'll need to worry about hitting that any time soon
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 12:00 pm
Steve Jones - Editor (7/26/2010)
Michael Valentine Jones (7/26/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 11:08 am
Nevyn (7/26/2010)
The way "money" and thus "isnumeric" handles commas seems to be fairly dumb, though.
Tell me about it.
There are days that I'd kill for an IsNumeric that returns...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 11:05 am
apat (7/26/2010)
select isnumeric('100,200') gives me 1.Shouldn't it be 0?
No.
SELECT CAST('100,200' AS MONEY)
Result:
100200.00
IsNumeric returns true if the value can be case to one of more of the numeric data types. Which...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 10:23 am
I can see it's a single line. What I'm asking is whether that should be a single column or multiple. It looks like there are multiple things in there. If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 10:18 am
Since the column name is a reserved word, you need to enclose it in [] every time you reference it.
select cvnt_page_stub, overview_control_id, status_id_list, [order]
from dbo.LU_OVERVIEW_CONTROL_PAGE locp
order by [order]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2010 at 6:45 am
Viewing 15 posts - 31,621 through 31,635 (of 49,552 total)