Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't remove fragmentation is wrong....

Good point to share regarding this QotD.

Biggest tables I've been working on are some with about 30-50 columns, 10-20 FKs, 150-400 million rows and sizes between 100-200 GB.

Let's see some...

Another one from me,

Wish you success with your work further...

Regards,

Igor

Hi

Swaping out real SSN with fakes will possibly cause other issues.

I used to do the same thing with scrambling the names, addresses and DOBs

Encryption of SSNs is a good option...

Following the De Morgan lows, this is practically the same as

WHERE (T1.Branch != T2.Branch) OR (T1.Branch !=...

Hi

In your select

SELECT *

FROM OPENQUERY(ADSI,'SELECT cn,SamAccountName, ADsPath FROM ' 'LDAP://DC=DomainName,DC=com' ' WHERE bjectCategory=' 'person' ' AND objectClass=' 'user' ' ')

why do you have ' 'LDAP://DC=DomainName,DC=com' ' ? You should have...

CTRL+T - for text

CTRL+D - for grid

in my ssms 2008r2, 2012 and 2014.

Thanks for sharing

BR

Igor

Misread too, considering those that can store store... :smooooth:

Good one, had to check it.

Thanks

Igor

tlou.mone (4/26/2014)

---

hello everyone

can you please help.I have downloaded SQL Server 2008(im a novice). i wnt to use management studio but cannot connect to an instance.Question: Can u connect to an...

Thanks a lot, Steve.

Learned something new.

Regards,

Igor

Thanks for this new-feature question.

Regards,

Igor

Just tested this yesterday 🙂

Good question!

Thanks

Igor

This is a great new feature in Sql Server 2014

Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)

ALTER SERVER CONFIGURATION

SET BUFFER POOL EXTENSION ON

(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50 GB);

Thanks

Igor