Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, May 23, 2018

Checking CHECKDB

SQLServerCentral » Latest topics
Checking CHECKDB
Comments posted to this topic are about the item [B]Checking CHECKDB[/B]

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

SQLServerCentral.com Articles
Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.

Tuesday, May 22, 2018

【购买各国毕业证】办理、代办英国文凭Q/微501146313办阿斯顿大学毕业证书办 Aston毕业证成绩单学历认证Aston University

SQLServerCentral » Latest topics
【购买各国毕业证】办理、代办英国文凭Q/微501146313办阿斯顿大学毕业证书办 Aston毕业证成绩单学历认证Aston University
【学历认证顾问QQ微信501146313】英国文凭,美国文凭,加拿大毕业证,澳洲成绩单,新西兰学历,新加坡,德国,法国,荷兰,意大利,奥地利,日本,韩国本公司专业为留学生解决以下问题:一、办理假毕业证在国内能用吗挂科拿不到毕业证怎么办 毕业证丢了怎么办没有正常毕业怎么办理毕业证没毕业可以办学历认证吗您是否因为中途辍学、挂科而没有正常毕业您是否因为递交材料不齐而被拒之门外您是否因没正常毕业而导致回国得不到教育部认证在校挂科了不想读了、成绩不理想怎么办找工作没有文凭怎么办办理本科/研究生文凭有本科却要求硕士又

Monday, May 21, 2018

Comic for 2018.05.21

RSSMix.com Mix ID 8239024
Comic for 2018.05.21
New Cyanide and Happiness Comic

Scheduling a PowerShell Script Using SQL Server Agent

SQLServerCentral.com Articles
Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.

杜塞尔多夫大学本科毕业证书*德国毕业证~Q微信857767150|办理杜塞尔多夫大学本科学历文凭认证/制做德国本科文凭

SQLServerCentral » Latest topics
杜塞尔多夫大学本科毕业证书*德国毕业证~Q微信857767150|办理杜塞尔多夫大学本科学历文凭认证/制做德国本科文凭
杜塞尔多夫大学毕业证/德国毕业证,Q/微:857767150,专 业 为 留 学 生办 理毕 业 证、成 绩 单、使 馆 留 学 回 国 人 员 证 明、教 育 部 学 历 学 位 认 证,网 上 存 档 永 久 可 查!
留 学 回 国 服 务 中 心:实 体 公 司,注 册 经 营,行 业 标 杆,精 益 求 精!
为 留 学 肄 业 生 提 供 以 下 服 务:
一、真 实 教 育 部 认 证,教 育 部 存 档,中 国 教 育 部 留 学 服 务 中 心 认 证(即教

SQL Server on Linux, does it have Microsoft's full attention?

SQLServerCentral.com Articles
SQL Server on Linux, does it have Microsoft's full attention?

SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?

Database Password

SQLServerCentral » Latest topics
Database Password
Hi

I use Control M for batch activity. When installing Control M you specify db names and passwords. However, when trying to run a reporting tool specifying the db owner and password it says password not recognised even though I know it is correc

Comic for 2018.05.20

RSSMix.com Mix ID 8239024
Comic for 2018.05.20
New Cyanide and Happiness Comic

Sunday, May 20, 2018

Today's Random Word!

SQLServerCentral » Latest topics
Today's Random Word!
HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene or a word running through your mind... Jump on that word... And. Post it here by it's thumbs! :hat: Quickly! Before it becomes a number!

Saturday, May 19, 2018

Comic for 2018.05.19

RSSMix.com Mix ID 8239024
Comic for 2018.05.19
New Cyanide and Happiness Comic

Friday, May 18, 2018

Comic for 2018.05.18

RSSMix.com Mix ID 8239024
Comic for 2018.05.18
New Cyanide and Happiness Comic

SQL Cluster one instance fails when failed over

SQLServerCentral » Latest topics
SQL Cluster one instance fails when failed over
I built two windows 2012 R2 VM (VMWARE) Cluster servers with SQL 2014 Enterprise 
Installed instance One have databases loaded and when I fail over to Node 2 all is good users do not even feel a bleep.
Installed instance two no databases

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

SQLServerCentral.com Articles
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

Transfer SQL Server Objects: SQL 2005 -> 2017: "Cannot read property IsColumnSet."

SQLServerCentral » Latest topics
Transfer SQL Server Objects: SQL 2005 -> 2017: "Cannot read property IsColumnSet."
Hi All

I have a Transfer SQL Server Objects task to copy tables from SQL 2005 to SQL 2016 with an SSIS target version of SQL 2016 and it works perfectly fine.
I have targeted this to SQL 2017 and I get the following error:

"Cannot re