Viewing 15 posts - 2,116 through 2,130 (of 9,641 total)
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...
October 8, 2011 at 6:45 am
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...
October 7, 2011 at 9:48 pm
laddu4700 (10/7/2011)
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...
October 7, 2011 at 9:38 pm
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.
October 7, 2011 at 9:30 pm
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...
October 7, 2011 at 9:29 pm
stephenmbell (10/7/2011)
I need them to be able to read from 4 views, and read write to 2 tables.
Here is the kicker -...
October 7, 2011 at 9:19 pm
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...
October 7, 2011 at 9:16 pm
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/....
October 7, 2011 at 9:13 pm
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...
October 7, 2011 at 8:42 pm
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...
October 7, 2011 at 8:36 pm
Ninja's_RGR'us (10/7/2011)
Roy Ernest (10/7/2011)
Ninja's_RGR'us (10/7/2011)
I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.
No...
October 7, 2011 at 9:23 am
Lynn Pettis (10/6/2011)
GilaMonster (10/6/2011)
Lynn Pettis (10/6/2011)
GilaMonster (10/6/2011)
Lynn Pettis (10/6/2011)
Didn't GETDATE() use to (or still get) the same error?Yes, in SQL 2000.
Then the code Jack ran into my be a vestige...
October 6, 2011 at 2:12 pm
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
...
October 6, 2011 at 12:39 pm
I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.
Never really listened to the Ramones, although I'm...
October 6, 2011 at 12:27 pm
Certainly an out of the box method to be notified of a failover. As mentioned it has some issues, but certainly could be part of an overall plan. ...
October 6, 2011 at 6:28 am
Viewing 15 posts - 2,116 through 2,130 (of 9,641 total)