Viewing 15 posts - 601 through 615 (of 9,643 total)
sheik.kalidh (10/21/2014)
firewall is completely off on both machines, where am able to connect in one way (i.e from A to B) and not in other way (i.e from B to...
October 21, 2014 at 8:00 am
DBA_Learner (10/20/2014)
But, this is what the O/P i am expecting....TO GET 4th column with difference in growth from datafilesize column...
name ...
October 20, 2014 at 12:03 pm
I'm glad you were able to successfully do what needed to be done, but I wouldn't recommend making a habit of just making changes like this in production. You...
October 20, 2014 at 9:40 am
You need to Enable a network protocol to allow connectiosn to the SQL Server. Here's an article on how to do it, http://msdn.microsoft.com/en-us/library/ms191294.aspx. If that doesn't work you...
October 20, 2014 at 9:33 am
I think you really want to change your query. Your actual file sizes shouldn't change on a daily basis, but the space used by the files could and should...
October 20, 2014 at 9:20 am
Since all the conditions in the WHERE clause of the NOT EXISTS query are OR'd together it only takes one of the criteria to match in order to get a...
October 20, 2014 at 9:01 am
Shawn Melton (10/17/2014)
October 17, 2014 at 11:35 am
A server-side trace has minimal impact and would be the way I'd recommend going about it on SQL 2005.
All DDL triggers, including LOGON triggers are AFTER triggers, so changing from...
October 17, 2014 at 11:00 am
There's no easy way to do it. What I've done, and it is a hack, is create a different SQL Agent job where step 1 checks for data from...
October 17, 2014 at 10:57 am
Looks like google is having a problem with "19900101..99991231". If you remove that the search works. Don't know why, but that seems to be the issue.
October 17, 2014 at 10:54 am
You need to tell sp_executesql that @outDupCheck is an output parameter as well. So your query needs to look that this:
EXECUTE sp_executesql @sqlStr, @ParmDefinition, @strAccount = @parmINAccount, @intHospital...
October 15, 2014 at 1:04 pm
Because FLOAT is not precise, it could actually be stored as 9956.587499999, and is displaying 9956.5875 so ROUND would leave it at .587 not rounding up to .588
October 15, 2014 at 1:00 pm
TomThomson (10/15/2014)
Luis Cazares (10/14/2014)
October 15, 2014 at 9:07 am
Without knowing what tables are involved it is hard to give you a complete answer, if you were to post your question using the guidelines in the top link in...
October 15, 2014 at 6:24 am
Luis Cazares (10/14/2014)
October 14, 2014 at 1:38 pm
Viewing 15 posts - 601 through 615 (of 9,643 total)