mga MSSQL admin please share your ideas and knowledge

[defender_1611]

---

Since your using SQL Server Standard Edition rebuilds ain’t awesome. If you’ve got SQL Server Standard Edition, index rebuilds are always an offline operation. Bad news: they’re also single-threaded.

[nyor]

yes ok ra....‘rebuild’ creates a fresh, sparkling new structure for the index. If the index is disabled, rebuilding brings it back to life.

- - - Updated - - -
@nyor

if you choose Rebuild or Reorganize much better if imo nalang e reorganize kay this option is more lightweight. It runs through the leaf level of the index, and as it goes it fixes physical ordering of pages and also compacts pages to apply any previously set fillfactor settings. This operation is always online, and if you cancel it then it’s able to just stop where it is (it doesn’t have a giant operation to rollback).

dli rmn kaha affected ang application after ma rebuild ang index sir? ky plan nko e.rebuild or reorganize kanang time nga e.maintain ang mga server's nya walai nag gamit sa database.. so ok ra kng offline ang rebuild.. nya ok ra kng 80 ang fill factor?

- - - Updated - - -

Since your using SQL Server Standard Edition rebuilds ain’t awesome. If you’ve got SQL Server Standard Edition, index rebuilds are always an offline operation. Bad news: they’re also single-threaded.

unsai pasabot anang single-threaded sir?

[nyor]

up for today

[anggwaponi]

--- updating ---







SQL QUESTION | ‘End of Support’ is not ‘End of Life’
NOTE: News link courtesy of interaksyon.com

[defender_1611]

musta mga boss? karon ra ko kabalik diri nga thread dah.....ipdayon pa ta ni? hehehe.

[defender_1611]

if you have any queries or questions just post it here I will be glad to help and answer you....

[rjbhern]

if you have any queries or questions just post it here I will be glad to help and answer you....

Sir @defender_1611 everytime mo.open ko sa among system para magpa.display and report (crystal report) in.ana nga error ang mo.gawas. pero ang OS nga gigamit ky windows 10. kana akong screenshot ky XP raman na. pero in.ana jud ang error nya. compatibility issue raba ni sir? ky sa among windows 7 okay raman cya. mo.display raman. any fix para ani sir?
we are using: MS SQL Server 2008 R2.
http://www.sqlcoffee.com/images/Trou...ting075-01.PNG

[defender_1611]

Sir @defender_1611 everytime mo.open ko sa among system para magpa.display and report (crystal report) in.ana nga error ang mo.gawas. pero ang OS nga gigamit ky windows 10. kana akong screenshot ky XP raman na. pero in.ana jud ang error nya. compatibility issue raba ni sir? ky sa among windows 7 okay raman cya. mo.display raman. any fix para ani sir?
we are using: MS SQL Server 2008 R2.
http://www.sqlcoffee.com/images/Trou...ting075-01.PNG

You have a mismatch of two different collations in your table. You can check what collations each column in your table(s) has by using this query:

SELECT
col.name, col.collation_name
FROM
sys.columns col
WHERE
object_id = OBJECT_ID('YourTableName')

Once you settled for one collation you may run this one.

ALTER TABLE YourTableName
ALTER COLUMN OffendingColumn
VARCHAR(100) COLLATE Latin1_General_CI_AS NOT NULL

The root cause is that the sql server database you took the schema from has a collation that differs from your local installation. If you don't want to worry about collation re install SQL Server locally using the same collation as the SQL Server 2008 database.

[nyor]

musta mga boss? karon ra ko kabalik diri nga thread dah.....ipdayon pa ta ni? hehehe.

Welcome back Boss.. ato ni ipadayon.. hehe!

[nyor]

Naa ba training center diri sa cebu nag offer ug Querying Microsoft SQL Server nga course?