Viewing 15 posts - 23,401 through 23,415 (of 49,552 total)
LutzM (9/20/2011)
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
September 20, 2011 at 1:21 pm
Welcome to the wackiness that is SQL error handling. This is pretty much the sole case where a statement fails, the connection remains open and the transaction rolls back.
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
September 20, 2011 at 1:16 pm
n_parker (9/20/2011)
First would be based on the ID and SubID fields combined
So what makes the first one Georgia and not Texas? Same ID, same SubID
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
September 20, 2011 at 1:13 pm
SQLRNNR (9/20/2011)
GSquared (9/20/2011)
GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
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
September 20, 2011 at 1:04 pm
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
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
September 20, 2011 at 12:42 pm
Nothing different.
RESTORE DATABASE <new name> FROM DISK = <backup location>
WITH MOVE <files to a new place>, NORECOVERY
RESTORE LOG <new name> FROM DISK = <Backup location>
WITH NORECOVERY
..
--repeat for rest of...
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
September 20, 2011 at 12:26 pm
Restore to a new DB, restore logs, copy data over.
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
September 20, 2011 at 12:17 pm
M_E_K (9/20/2011)
You are right about the redundant predicates. Also, if I remove the second one, the query completes in no time and gives a good execution plan.
I suspected something like...
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
September 20, 2011 at 12:07 pm
I hate to say it, but Pinal is wrong. If you set 100% fill factor on a clustered index and the rows really do fill the page then any update...
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
September 20, 2011 at 11:39 am
Read up on Grouping Sets (or post the information I asked for)
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
September 20, 2011 at 11:37 am
Yuri, your code will work fine because it doesn't explicitly reference a column that doesn't exist.
This will fail though:
EXEC sp_Msforeachdb
'
if left(''?'', 5) = ''MyDB_''
begin
use [?];
if exists (select * from syscolumns...
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
September 20, 2011 at 11:35 am
Ninja's_RGR'us (9/20/2011)
GilaMonster (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Not 100% sure if the plan in cache has that info, I would guess it does (I don't usually use that to pull out plans).
No, it doesn't....
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
September 20, 2011 at 11:33 am
I'd be looking at a few things:
Widen the index [OLAP].[dbo].[W_SRVREQ_F].[W_SRVREQ_F_F10], add ACCNT_WID, SR_WID and DURATION_MINS as include columns.
Change the where clause:
case when T68314.[STATUS] = N'Closed' then N'RESOLVED' when T68314.[STATUS]...
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
September 20, 2011 at 11:32 am
Huh?
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
September 20, 2011 at 11:18 am
onlygoodones (9/20/2011)
My research shoed 100% fill factor is best if u have an identity column with Clustered index.
No usually. If the fill factor is 100% (and the rows do...
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
September 20, 2011 at 11:18 am
Viewing 15 posts - 23,401 through 23,415 (of 49,552 total)