Viewing 15 posts - 9,616 through 9,630 (of 49,552 total)
As the error clearly says, it's a unique constraint. Therefore the constraint has to be dropped and recreated.
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 18, 2014 at 4:45 am
Insert a new row?
So, if the user selects all 25 columns one by one, then you want to have 25 separate rows in the database table, each with a single...
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 18, 2014 at 4:35 am
Something's blocking the drop index. Identify what that is and either wait for it to finish or kill the session. Then drop those indexes and recreate them.
Do it in code,...
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 18, 2014 at 4:23 am
What are you trying to do?
Of course that's going to insert the value twice, there's no conditions around the insert. The WHERE is just on a select of the parameter,...
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 18, 2014 at 4:12 am
Drop the indexes. Recreate them. Don't rebuild, it won't fix anything. You have to drop and then recreate.
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 18, 2014 at 4:03 am
praneethydba (3/18/2014)
HI All,Today my physical memory reached to 80% in my database server.
Please suggest what to do to reduce it now...
Nothing. Same as I suggested last time, and the time...
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 18, 2014 at 3:42 am
Please post the rest of the output of CheckDB.
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 18, 2014 at 3:39 am
Do the restore from T-SQL, post the exact error message.
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 18, 2014 at 12:28 am
Only writes to the log are synchronous. Writes to the data file happen later.
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 17, 2014 at 2:53 pm
Sure. File in filegroup 1 on disk 1, file in filegroup 2 on disk 2. However a table (or at least a partition) must be in a single filegroup.
this...
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 17, 2014 at 10:15 am
Sure, once I've found a few hours to sit and investigate the scenario you're describing, figure out what's happening.
The log is not an audit trail, don't try to use it...
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 17, 2014 at 10:08 am
Re inserts.
Once over a few pages (8 or 24, can't recall), SQL allocates dedicated extents to tables. So 8 contiguous pages. So what's happening probably is 8 pages from one...
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 17, 2014 at 10:03 am
Jeff Moden (3/17/2014)
To be clear, my response was based on the OP's claim of having a single file per filegroup.
He corrected that statement in a later post
msmithson (3/14/2014)
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 17, 2014 at 9:47 am
I'd have to sit and play with the log for a few hours to figure out what you're describing. It's not documented at all, it changes from version to version,...
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 17, 2014 at 9:44 am
And when you run the proc from SQL as I suggested?
Those are compile-time warnings, not interested in compile-time messages, interested in the run-time errors (if any) from SQL Server.
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 17, 2014 at 9:39 am
Viewing 15 posts - 9,616 through 9,630 (of 49,552 total)