Viewing 15 posts - 24,871 through 24,885 (of 49,552 total)
jwbart06 (7/15/2011)
Weird thing you don't have to have the same size of data type.
No, they just have to be implicitly convertable.
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 15, 2011 at 3:20 pm
mortalic (7/15/2011)
Ok, I think I understand, one last question then, wouldn't the index rebuilds cause it to grow significantly though?
If there's not enough free space in the DB file (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
July 15, 2011 at 3:19 pm
We're suggesting you don't shrink it at all. You're not gaining yourself anything. You shrink it, SQL grows it again (for index rebuilds, normal usage), you shrink it, SQL grows...
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 15, 2011 at 12:18 pm
Call customer support. They have the tools to interpret this and understand what caused it, we don'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
July 15, 2011 at 10:10 am
opc.three (7/15/2011)
In addition to getting onto 64-bit I was also hoping to learn about some SQL Server hosting providers thatactually keep up with the technology.
I can't see any hosting...
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 15, 2011 at 10:10 am
mortalic (7/15/2011)
I should clarify the shrink job is for the data file not the log file, I misspoke in my earlier post.
That's even worse. A shrink of the log can...
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 15, 2011 at 10:07 am
The order has to be the same in all of the queries you're unioning together. Beyond that, the general order of the columns in the query as a whole 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
July 15, 2011 at 8:40 am
Subrata Bauri (7/15/2011)
I will increment the value of this Column at the Time of Data Insertion in this CASE.
If you're doing an INSERT.. SELECT, or bulk-insert, all the rows will...
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 15, 2011 at 8:33 am
Welsh Corgi (7/15/2011)
Not everyone on this forum is a Sir and quite frankly I know of some very smart Ladies that are the most bulbs on the Christmas Tree.
Definitely...
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 15, 2011 at 8:30 am
The one case that comes to mind is a staging table. If I'm importing data from some other system and I know that it's got data integrity issues, I'll 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
July 15, 2011 at 6:18 am
Jayanth_Kurup (7/15/2011)
However the first can be achieved simply by adding a identity column while the second is driven by the kind of data being inserted into the table.
Identities alone don'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
July 15, 2011 at 6:03 am
rnoakhali (7/15/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
July 15, 2011 at 6:02 am
Jayanth_Kurup (7/15/2011)
Run checkpoint and then try doing a shrink file
Checkpoint does not make the log reusable in full recovery. As mentioned previously shrinking is probably a bad idea 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 15, 2011 at 5:59 am
Welsh Corgi (7/15/2011)
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?
That question is tagged Oracle and the answers are Oracle-specific. Can't draw conclusions...
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 15, 2011 at 5:58 am
Rollbacks are complete. Other than table variables, I can't think of any DDL operations within a database that can't be rolled 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
July 15, 2011 at 5:13 am
Viewing 15 posts - 24,871 through 24,885 (of 49,552 total)