Viewing 15 posts - 4,276 through 4,290 (of 49,571 total)
robert.sterbal 56890 (11/16/2015)
GilaMonster wrote:Second? Well past 20th in the two cases that triggered that post.
I'm going to ignore your (repeated) implication that I don't try to teach people. Feel free...
November 16, 2015 at 1:23 pm
Brandie Tarvin (11/16/2015)
Ed Wagner (11/16/2015)
BrainDonor (11/16/2015)
djj (11/16/2015)
November 16, 2015 at 9:13 am
robert.sterbal 56890 (11/16/2015)
Can you use it as a teachable moment? Maybe the second time you observe the lack of thought?
Second? Well past 20th in the two cases that triggered that...
November 16, 2015 at 9:09 am
Backup time is mostly IO subsystem, reads from the source DB, writes to the backup device.
Check perfmon for the latency on the drives involved, speak with your storage admin about...
November 16, 2015 at 8:59 am
PageIOLatch is an IO subsystem wait. Maybe chat with your storage admin as to why you're seeing IO-related waits?
November 16, 2015 at 3:40 am
polkadot (11/15/2015)
November 15, 2015 at 4:13 pm
Also note that your tests are not actually equivalent
The first one updates all rows to a particular value, not, as you indicated "update the values in the Unitcost column of...
November 15, 2015 at 2:00 pm
polkadot (11/15/2015)
I usually wonder why LIKE isn't used insteadie.
where yourColumn has numbers eg. LIKE '%[0-9]%'
Probably because they do two different things
NOT LIKE '%[^0-9]%'
Return the rows where the column consists of...
November 15, 2015 at 1:37 pm
TOP 1 goes before the variable name, not after. As written, you're saying
@currentMYID = TOP, which is obviously not what you intend.
November 15, 2015 at 4:33 am
I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really too...
November 14, 2015 at 12:27 pm
That's exactly how you normally use SQL Server. Install SQL in the central server, put the database on there, then you application connects to that SQL instance.
If you don't know...
November 14, 2015 at 12:06 pm
Try MIN(OrderMonth) OVER (<windowing clause>)
November 14, 2015 at 7:57 am
You should have been clear in your title and post that you were asking about Availability Groups, not clustering (which the title stated)
November 14, 2015 at 7:56 am
Neither of those are feasible for Always On Failover Clustering. With failover clustering, the instance fails over. The first would work if you put two instances on the HA server,...
November 14, 2015 at 1:45 am
To be honest, the performance if probably the smallest problem there. That code has race conditions in it. I suspect it's throwing the occasional unique constraint violation (and if not,...
November 14, 2015 at 1:41 am
Viewing 15 posts - 4,276 through 4,290 (of 49,571 total)