parissa_bakhshi (10/8/2011)

---

Think it's not a real cluster when you have different network names. What was the reason for using different network names for SQL resources? You can install a new...

Stefan Krzywicki (10/8/2011)

---

L' Eomot Inversé (10/7/2011)

---

Stefan Krzywicki (10/7/2011)

---

I've spent my entire career trying to take jobs I don't think I'm quite qualified for, that gives me room to grow and...

That's what I get for doing it after my bedtime. It's also a reason I hate table names like that. What the heck is an ACSU or SCSU...

In my opinion EF is better than Linq to SQL. Like anything it can be used well or poorly. I prefer to use stored procedures because I believe...

laddu4700 (10/7/2011)

---

Hi,

One of our dev database is in suspect mode, not sure what went wrong.

Below are the details

DBCC CHECKDB (My1C_DevMS) WITH NO_INFOMSGS, ALL_ERRORMSGS

Msg 926, Level 14, State 1, Line...

Extended events is probably the feature you should use for this, but you could also write a server-scoped DDL trigger to catch this as well.

No worries. I did a quick test where I stored results of sys.dm_db_index_physical_stats, did a compressed backup, restored the backup, and did another query of sys.dm_db_index_physical_stats and ended up...

stephenmbell (10/7/2011)

---

I am using windows authentication via an AD group.

I need them to be able to read from 4 views, and read write to 2 tables.

Here is the kicker -...

What does a query of sys.traces report for event_count? If you don't have many or any events collected then the file will be small. Have you tried opening...

I think you are looking at the right path with DNS. I'd suggest changing to using DNS Aliases (CNAMEs) as mentioned in this blog post by Allen Kinsel, http://www.allenkinsel.com/archive/2010/01/using-aliases-in-sql-server/....

You don't want the UNION you want 1 query with 2 COUNTs like this:

SELECT

tblUCSU.strLocationName,

COUNT(dbo.tblTACSU.Pen) AS Trunks,

COUNT(dbo.tblSCSU.Extension) AS...

To the best of my knowledge backup with compression will not cause any fragmentation. It is a compressed copy of the database in the form it was in when...

Ninja's_RGR'us (10/7/2011)

---

Roy Ernest (10/7/2011)

---

Ninja's_RGR'us (10/7/2011)

---

Ok to bring this back on topic.

I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.

No...

Lynn Pettis (10/6/2011)

---

GilaMonster (10/6/2011)

---

Lynn Pettis (10/6/2011)

---

Then the code Jack ran into my be a vestige...

So working on a system where there is a UDF that calls a view and the view definition is:

create view SYSTEM_DATE_VIEW

as select getdate() SYSTEM_DATE

...