Viewing 15 posts - 13,771 through 13,785 (of 49,552 total)
Chrissy321 (3/21/2013)
SELECT * FROM @test1WHERE
Field1 + CONVERT(varchar(1),Field2) NOT IN
(
SELECT Field1 + CONVERT(varchar(1),Field2) FROM @Test2
)
SELECT * FROM @test1 t2
WHERE NOT EXISTS (SELECT 1 FROM @Test2 t2 WHERE t1.Field1...
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
March 22, 2013 at 4:30 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
March 22, 2013 at 3:48 am
Not really that way, depends on the database activity, the portion of the DB that is heavily used, the workload and a whole bunch of other things.
For what to leave...
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
March 22, 2013 at 3:47 am
It's in the suspended state because it's waiting for a mail to send. When a mail is sent, it will run, send the mail then go back to waiting 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
March 22, 2013 at 3:45 am
SQL* (3/22/2013)
The user data will be written to the Primary File Group, if there is an error while writing, Is this database will be available?
Maybe....
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
March 22, 2013 at 3:25 am
Please post new questions in a new thread. Thanks
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
March 21, 2013 at 5:25 pm
The thing is, the memory allocated by AllocPhysicalPages is known as AWE memory, so it's not a misleading display, it's correct. AWE does not just mean the 32 bit memory...
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
March 21, 2013 at 11:56 am
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/
The 'table variables are memory only' is an all-too-common misconception. Both temp tables and table variables are allocated space in TempDB and added to the tempDB system tables. They may...
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
March 21, 2013 at 11:42 am
DEpends whether the sort's expensive enough to justify a duplicate index.
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
March 21, 2013 at 11:28 am
mehta.saurabhj (3/21/2013)
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
March 21, 2013 at 9:37 am
If it's a NAS, you need to make very sure that is supports SQL's IO requirements. SQL requires write order preservation and that there be no sector rewrites.
IO contention won'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
March 21, 2013 at 8:11 am
It might. Test it, test a stats update and see which if either makes a noticable difference
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
March 21, 2013 at 6:57 am
bugg (3/21/2013)
Would it be okay after the insert to do an index rebuild before the update?
Is the index rebuild necessary?
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
March 21, 2013 at 6:26 am
Transactional replication?
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
March 21, 2013 at 4:19 am
Don't mix up the AWE memory allocation API, which is used any time that locked pages is enabled, and the AWE setting which is only for 32 bit SQL.
Yes, 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
March 21, 2013 at 3:48 am
Viewing 15 posts - 13,771 through 13,785 (of 49,552 total)