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...

djj (4/23/2014)

---

Hello, Is there a difference in the following: DECLARE @T1 VARCHAR(50);

SET @T1 = (SELECT TOP(1) Col1 FROM MyTable); -- define variable first way

SELECT TOP(1) @t1 = Col1...

Of course, by breaking the MCM mold, Microsoft has insured that these minted certifications are now even more exclusive and valuable. 🙂

Given the cirsunstances, it's probably best to just hard code the definition of the temp table, which is the typical way of doing it. I wouldn't even dick around with...

Jeff Moden (4/21/2014)

---

Eric M Russell (4/21/2014)

---

Jeff Moden (4/20/2014)

---

Tom Brown (4/15/2014)

---

However on this particular project they don't like linked servers/openquery etc - So I don't have the Access level required...

In addition to the general advice "never stop learning", another piece of advice is "never stop browsing the job posting sites". The career advice dispensed by your mom the school...

Jeff Moden (4/20/2014)

---

Tom Brown (4/15/2014)

---

However on this particular project they don't like linked servers/openquery etc - So I don't have the Access level required - and almost certainly the...