Viewing 15 posts - 1,426 through 1,440 (of 5,843 total)
dandenise316 (8/20/2015)
How would one approach this?
Based upon the attributes in 2 fields (volume of mail...
August 20, 2015 at 7:32 am
Sounds like a data mining problem. That subsystem has been included with SQL Server since, what, SQL Server 2000? And almost no one is using it!! Not using that is...
August 19, 2015 at 2:33 pm
ryanjb1989 (8/19/2015)
The...
August 19, 2015 at 10:54 am
Ken at work (8/18/2015)
I found it....The values are not real they are numeric(9,2). I'm still not sure why they were rounding but at least this fixes it.
I still don't...
August 19, 2015 at 8:32 am
Tim Walker. (8/19/2015)
GilaMonster (8/19/2015)
August 19, 2015 at 7:13 am
Can't do anything with a picture. But a scan doesn't necessarily mean what you think sometimes. What is the actual row count entering that table on the loop? What is...
August 19, 2015 at 6:58 am
IMPLICIT CONVERSIONS can be a REAL shock and PAIN-CAUSER in SQL Server. The alternative is getting the wrong answer with no warning or error (which is by FAR the worse...
August 19, 2015 at 6:21 am
Tim Walker. (8/19/2015)
I often use profiler as one tool to help identify bad plans. The reads column gives me a...
August 19, 2015 at 6:19 am
Ken at work (8/18/2015)
TheSQLGuru (8/18/2015)
assuming both datatypes ARE real, cast the hard-coded values in the isnulls to the same datatpye - not the result of the isnull.
I'm not sure what...
August 18, 2015 at 7:23 pm
assuming both datatypes ARE real, cast the hard-coded values in the isnulls to the same datatpye - not the result of the isnull.
August 18, 2015 at 2:29 pm
Perry Whittle (8/18/2015)
TheSQLGuru (8/18/2015)
(if AG fails over, how would log shipping work then?)It involves a special LS configuration and requires in depth knowledge
Yes, yes it does! 😎
August 18, 2015 at 10:27 am
1) Have you patched up SQL Server (and Windows)?? There were quite a few patched bugs with AGs.
2) When you set things up, did you follow the LARGE amount of...
August 18, 2015 at 7:54 am
ramana3327 (8/18/2015)
We have 4 node cluster with sql cluster in always on. How do you maintain an this hadr? In addition to that we are using logshipping to different server...
August 18, 2015 at 7:42 am
GilaMonster (8/17/2015)
August 17, 2015 at 12:06 pm
What is the code of the referenced objects too? They could be got-knows-what-containing views/mTVFs, etc.
August 17, 2015 at 7:58 am
Viewing 15 posts - 1,426 through 1,440 (of 5,843 total)