Viewing 15 posts - 301 through 315 (of 469 total)
The call to MICROSOFT is FREE OF COST...under MS policy, SUPPORT for SECURITY UPDATES is at NO COST...make sure you let them know this, also make sure you installed it...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:51 am
The security update requires it to be installed with the 'sa' account for it to be successful. Once that is done, reboot the system and go to services and check...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:45 am
The update I ran is this:
Update dbo.ReportblCust
Set ValidMsgDisp = ReportblCust.ValidMsgDisp
From
ReportData_DPS.dbo.ReportblCust Join
ReportData_DPSTest.dbo.ReportblCust On
...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 9:28 am
I ran this replacing the table and db names with the ones i have on the destination database. It says 20 rows affected but does not reflect those changes on...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 9:24 am
how would an update be on the PK column? Will my life be easier if I use DTS and copy the table, the data in it is static so we'll...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 8:55 am
But the Developers don't know to backup a table before doing an update. Also at my place the developer didn't make the update statement as part of the transaction and...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 8:40 am
Ahh..looks as it I just wasted a topic. I am done with the Indexing, took like 30 seconds only..Thanks anyways!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 8:30 am
The title name should have been 'Time to Create Index'...I guess that was a typo..:P
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 7:37 am
REBUILD LIKE THIS:
DBCC DBREINDEX(tblName,'Index Names ',Fill Factor)
If you want to Reindex all the tables and on all the indexes use this:
exec sp_MSForEachTable '
print ''?''
DBCC DBREINDEX(''?'')
print ''-----------------------------------------------------------------''
'
Fill Factor: Ideally it should...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 7:19 am
Thanks Steve, I ran it a while ago. The available space is now shown at 784 MB.
Gail, thank to you too..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 11:42 am
Can I do it during the normal workload or is it to be done during off peak hours?
Thanks for your help..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 8:01 am
GilaMonster (11/13/2008)
The_SQL_DBA (11/13/2008)
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.Thanks!!
How do you propose...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 7:59 am
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 6:47 am
Imke Cronje (11/13/2008)
Will it be a good idea to drop the constraints on the database and then drop the clustered primary key indexes on the tables.
I don't think it is...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 6:42 am
But your logical scan fragmentation is low which is good. Also the page density, aka Fill Factor is high which is good too.
How about updating the statistics with full scan??...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 13, 2008 at 6:34 am
Viewing 15 posts - 301 through 315 (of 469 total)