Eirikur Eiriksson (4/29/2014)

---

Set MIN and MAX memory to the desired number

😎

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'min server memory (MB)', N'4096000'

GO

EXEC sys.sp_configure N'max server memory...

Dalkeith (4/29/2014)

---

There are two aspects of software which make it unique in the world of Economics.

Immortality and essentially Free Duplication.

Immortality usually leads to higher prices - eg gold diamonds etc

100%...

That's odd. Maybe you're lactose intollerant. Try...

Despite all the coders contributing to OpenSSL, they somehow missed an obvious buffer overflow bug that could be spotted in a production or test environment without even examining at the...

Steve Jones - SSC Editor (4/24/2014)

---

jarick 15608 (4/24/2014)

---

The push needs to come from someone in senior management with some security smarts. In my experience, very few executives have this...

Unfortunately there are many IT shops who treat their relational database like a digital landfill: no thought for normalization, constraints, or optimization. Archived emails, website clicks, basically...

Yeah, we get the joke, but at this point you could...

jarick 15608 (4/24/2014)

---

I did something like this only to learn that we were out of compliance with a vendor and had broken a support agreement. This was a large...

Another disadvantage of using triggers in place of constraints is that a newly created trigger won't validate existing rows, only newly inserted or updated rows. Also there are more scenarios...

If a software application is hard coded to use the "SA" account, you can rename it and then create a new account named "SA" with limited permissions. One or more...

It's amazing that googling the following will still return hundreds of actual server login credentials.

filetype:config connectionString uid password

Also SORT_IN_TEMPDB = { ON | OFF } depending on which filegroup (default or tempdb) has available free work space.

I believe that performing a clustered index reorganization is always an online operation, and LOB_COMPACTION (on by default) will also reclaim deallocated LOB pages, which is what Kumar really needs.

What...

Also, for sizing up a table that includes nText and nVarChar(max) columns, the sys.dm_db_partition_stats view can be used to return more detailed information about In Row allocation versus LOB and...

S_Kumar_S (4/23/2014)

---

ok, now the direction of problem changed totally after some findings. The clustered index was actually not rebuild by the maintenance job because table has a ntext column!!

And...