Viewing 15 posts - 16,576 through 16,590 (of 49,552 total)
And the question of how many columns in a table depends on a couple things, it's not a fixed number. Maybe they were wanting to see if you knew that....
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 18, 2012 at 6:05 am
Yup. You want changed, you need to compare the columns in the inserted and deleted tables.
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 18, 2012 at 6:04 am
Try it out in a test/dev environment first. Even if it's just your local machine.
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 18, 2012 at 5:55 am
Not quite...
It's checking whether ColumnA was one of the columns specified in the SET clause of the update statement.
UPDATE Tbl SET ColumnA = ColumnA
If you had an update trigger on...
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 18, 2012 at 5:54 am
Because the table's too small. The table comprises 2 pages perhaps. The general advice on where you worry about fragmentation is around 1000 pages.
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 18, 2012 at 4:24 am
ananda.murugesan (9/18/2012)
if separate physical disks on different array controller, it will get much performance also disk IO will be reduced.. and same thing SAN attached LUN configuration.
Maybe, maybe not. It's...
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 18, 2012 at 2:59 am
amirhh2000 (9/16/2012)
Can anyone please confirm that installation of SQL2005 Client Components is not possible on windows 64bit
I can confirm 100% that the installation if the SQL 2005 client tools is...
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 18, 2012 at 2:57 am
Are they object plans (procedure, trigger, function), parametrised or ad-hoc queries?
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 17, 2012 at 4:06 pm
A trigger fires once only for an operation. All the rows affected by the insert/update/delete will be in the inserted and/or deleted tables.
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 17, 2012 at 3:06 pm
You need to ensure that the database is not using any persistent Enterprise only features first. Compression, TDE, partitioning. If it is, you have to remove them first, then...
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 17, 2012 at 1:44 pm
Can you run a full CheckDB on whatever database threw the CheckTable errors?
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 17, 2012 at 1:06 pm
No, because you have corruption not associated with any table.
Repair rebuild will do nothing. The minimum level to repair that is repair_allow_data_loss. Use a level less than that and 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
September 17, 2012 at 11:36 am
You're going to have to identify which row have the bad values and update them (or you can just update the entire table and set the column say to 0,...
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 17, 2012 at 10:37 am
My advice from earlier stands. Repair or restore.
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 17, 2012 at 10:08 am
Database ID 27 could be the hidden snapshot that the integrity check uses. Can you try a full checkDB?
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 17, 2012 at 10:05 am
Viewing 15 posts - 16,576 through 16,590 (of 49,552 total)