Viewing 15 posts - 181 through 195 (of 1,068 total)
chaithu559 (6/12/2012)
Will the nonclustered pages at the level be updated in this scenario, mapping to key columns in CI ?
Yes. You are right.
June 12, 2012 at 3:34 am
Jai-SQL DBA (6/12/2012)
I read through ::::
But it didnt explained that it will require a Downtime..
Though it Slows down the Performance and thats Acceptable...
June 12, 2012 at 2:16 am
SQLUserC (6/11/2012)
Hey all,I just had a situation where changes I made at one location of a two node transactional replication setup did not replicate to the other server.
...
Are the...
June 11, 2012 at 11:58 pm
Thanks for correcting.
It was an error from my side. I meant PK column, not identity column.
June 7, 2012 at 12:13 am
Sourav-657741 (6/6/2012)
There is a database which has a high percentage of empty space being stored in buffer pool memory. This database is storing ~18% of its total buffer pool memory...
June 6, 2012 at 11:34 pm
SQL_Surfer (6/6/2012)
June 6, 2012 at 11:18 pm
jitendra.padhiyar (6/6/2012)
I setup transactional replication and come to konw that the table with primary key is only accepted for Transactional replication.
I dont konw why.. Can anyone help me...
June 6, 2012 at 11:13 pm
Rock from VbCity (6/6/2012)
... please follow these steps:...
Thanks for the detailed post with screen shots.
You can publish it as a blog or article. Becuase, I believe no one has published...
June 6, 2012 at 12:43 am
Are you using SQL Server or Access?
June 5, 2012 at 11:09 pm
What is your server RAM and MAX Server memory?
I guess you need to reduce your MAX Server memory.
How big is your Tlog backup file size?
What is the backup/restore frequency in...
June 5, 2012 at 10:29 pm
Krasavita (6/5/2012)
Hello,I need to create another instance on my server, how can I create it, do I need another lisense for that?
Thank you
To create another instance you need to run...
June 5, 2012 at 10:22 pm
What error second one gives you?
Put column name desc within square brakcets as it is reserved word.
Is autoincrement a UDDT (user defined data type)?
Don't use varchar for qty, price, etc....
June 5, 2012 at 10:09 pm
Open the package in BIDS.
Right click and select "Package Configurations..." or click on SSIS menu and select "Package Configurations..."
Click on "Enable package configuration" check box.
Click on "Add..." button.
....
June 5, 2012 at 5:01 am
Do you have PK in the table? If yes, you can use TABLEDIFF.EXE command line utitly. It comes with SQL Server.
June 5, 2012 at 3:46 am
Steve Jones - SSC Editor (6/1/2012)
June 1, 2012 at 9:59 pm
Viewing 15 posts - 181 through 195 (of 1,068 total)