Viewing 15 posts - 23,221 through 23,235 (of 49,552 total)
Not unless the primary key is enforced by a nonclustered 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
September 28, 2011 at 2:43 am
What's wrong with the native backups?
Personally, if I was going to use a 3rd party tool, it'd be one of RedGate's SQL Backup solutions.
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 28, 2011 at 2:25 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1182252-1549-1.aspx
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 28, 2011 at 2:05 am
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 28, 2011 at 2:04 am
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 28, 2011 at 1:37 am
Like that there's seldom a reason, especially if you're always doing equality matches on the column. If the columns were in another order, there could be a use.
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 28, 2011 at 1:35 am
isuckatsql (9/27/2011)
What do you suggest for phone numbers?Most of what i have found has been char, varchar or nvarchar.
char or varchar. nvarchar is Unicode, so 2 bytes per character in...
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 28, 2011 at 1:12 am
Call Tivoli support.
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 28, 2011 at 1:09 am
Steve Jones - SSC Editor (9/27/2011)
On a completely unrelated, and sideways note, anyone seen Khan Academy? http://www.khanacademy.org/
I'm enjoying some of the iTunesU stuff from the big name universities. An working...
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 27, 2011 at 5:15 pm
Anyone want to lend a hand here?
http://www.sqlservercentral.com/Forums/Topic1180942-391-1.aspx
I suspect, for good performance, the bit from the full text index needs to go into a temp table directly, no joins, no...
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 27, 2011 at 5:10 pm
Steve Jones - SSC Editor (9/27/2011)
Not that I'm asking for more political debates here, but if it comes up, nothing wrong with a little (meaning short, for Gail's sake), argument.
I...
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 27, 2011 at 5:10 pm
From permanent tables to global temporary tables. That's going to give you even more fun race-conditions and incorrect results if multiple of those queries are run concurrently.
I know you're new...
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 27, 2011 at 3:59 pm
WayneS (9/27/2011)
SQLRNNR (9/27/2011)
Evil Kraig F (9/27/2011)
SQLRNNR (9/27/2011)
Evil Kraig F (9/27/2011)
Trey Staker (9/27/2011)
Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass?...
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 27, 2011 at 2:31 pm
GSquared (9/27/2011)
Looks like The Thread may have killed the rest of the forums.The Active Threads link is only showing 5 other discussions.
It is a little quiet for a Tuesday night.
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 27, 2011 at 2:27 pm
opc.three (9/27/2011)
Heap fragmentation (which is extent fragmentation) is solely from inserts, allocating new extents that are not contiguous in the file.
Inserts and the creation of forwarded records, right? Physically speaking,...
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 27, 2011 at 2:23 pm
Viewing 15 posts - 23,221 through 23,235 (of 49,552 total)