Viewing 15 posts - 6,871 through 6,885 (of 22,211 total)
For managing dates like that, I'd suggest using the UTC date functions; SYSUTCDATETIME or GETUTCDATE. You can then use the timezone offsets to show the dates as local if necessary.
January 18, 2015 at 4:51 am
OK then. Hopefully those resources I linked to will help you out then.
January 18, 2015 at 4:44 am
OK. You may want to filter those results and eliminate some stuff that's not telling you anything. Here's a good article on that from Paul Randal. Most of your top...
January 17, 2015 at 7:28 am
The first thing that comes to mind is the fact that you're going to write a lot of OR statements to switch through these bit fields. That bothers me from...
January 17, 2015 at 6:45 am
CXPacket waits are just an indication of waits on threads in SQL Server. They don't indicate a performance problem at all really. A lot of people think they mean that...
January 17, 2015 at 6:40 am
First thing you can do is ping, and ping for the specific port that you have SQL Server configured for (default is 1433). After that, it really depends on what...
January 17, 2015 at 6:35 am
Excellent. Thanks Lowell. I did not know that.
January 16, 2015 at 6:42 am
There are a whole slew of performance monitor counters all dedicated to the Buffer Manager. That's the place I'd start.
January 16, 2015 at 5:10 am
Check out the lessons at Pluralsight.com. They have some specifically for that test. I'm starting to work on the 70-464 lessons right now.
January 16, 2015 at 5:00 am
Trace events on either machine should see the queries if you're capturing both rpc_completed and sqlbatch_completed.
January 16, 2015 at 4:58 am
That's an indication of long term blocking. It sounds like you need to tune your system or tune your queries. Deadlocks are also an indication of performance issues caused by...
January 16, 2015 at 4:57 am
If you mean DBCC, the options are limited. You can run a PHYSICAL_ONLY check that will just check the external storage of the data and not the internal storage. That...
January 16, 2015 at 4:53 am
It's all managed through the buffer manager. It will remove older stuff from cache in order to support newer stuff.
January 16, 2015 at 4:51 am
I'm not sure. There's nothing in the standard documentation. It almost looks like the first message is nothing but a warning and the second is the actual error. That certainly...
January 16, 2015 at 4:47 am
lshanahan (1/15/2015)
January 15, 2015 at 6:57 am
Viewing 15 posts - 6,871 through 6,885 (of 22,211 total)