Overcoming the OPENQUERY Record Limit for AD
Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.
2014-11-13
6,823 reads
LDAP
2012-09-07 (first published: 2007-11-15)
3,441 reads
RE: There is already an object named PK_Survey_Category in the database
I find that I get this problem if I rename a table from one name to another as Enterprise Manager does not change the keys/constraints. I find the best way to manage this is take the SQL script for the object and rename all of the objects (keys/constraints etc) before I create it and then […]
2004-05-19
RE: Not using all available memory
Count your blessings that it is not using all of the available memory. SQL Server will start at the min server memory when it starts up. As it performs more work (services new connections, reads index and data pages, creates/drops locks, etc.), it will acquire more memory from the OS up until it reaches the […]
2003-05-15
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers