Viewing 15 posts - 2,626 through 2,640 (of 49,552 total)
ScottPletcher (8/17/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 2:45 pm
Sue_H (8/17/2016)
Interesting...and no errors in the connectivity ring buffers in dm_os_ring_buffers. New twist on security maybe.
Probably failing too early in the connection process, before it got to a point...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 2:39 pm
That error sounds like the instance of SQL you're trying to connect to isn't running (via named pipes). Double-check the server names/instance names and make sure you're trying to connect...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 3:02 am
crazy_new (8/17/2016)
So what you are saying is that it is always using the clustered index to filter on if the query only filters in this ID?
No. It probably will be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 3:01 am
lianvh 89542 (8/17/2016)
Thank you for the feedback. It's much appreciated. One question though : Is it possible to replace Index rebuild with update statistics - fullscan?
You can, though whether that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 2:58 am
ScottPletcher (8/16/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2016 at 2:55 am
khushbu (8/15/2016)
Wanted to know how do I create partition function for date range >90 days
You don't. Not exactly
Partition boundaries have to be fixed values, so you can have a partition...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2016 at 3:11 pm
There's a reason I teach my devs to script out the restores before running them and check what the script does. 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2016 at 2:54 pm
I've done it before as well, using triggers. It's a pain in the neck to get right and keep in sync, and the queries to get the correct point in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2016 at 3:57 am
It must be getting created by some application installed (or possibly even some malware that's installed, the file names don't sound legit)
Try running a server-side trace for a while and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 3:10 pm
vsamantha35 (8/11/2016)
FYI we are pulling large datasets from different source systems and load data into a datawarehouse...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 3:07 pm
No, because timeouts are not a database setting.
A timeout is the application deciding it's waited too long and notifying SQL to stop the query. It is not SQL deciding...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 3:06 pm
WhiteLotus (8/11/2016)
Should I restore the databases in witness server?
No.
The witness is there solely to check whether it can see the principle or mirror to decide whether to failover the mirroring...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 3:02 pm
SQLTestUser (8/15/2016)
From the two time periods on Logdatetime itself
What two time periods? There's only one datetime per row.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 2:28 pm
Yes, but column statistics only, not index statistics (they got updated with the index rebuild)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2016 at 4:00 am
Viewing 15 posts - 2,626 through 2,640 (of 49,552 total)