Viewing 15 posts - 7,546 through 7,560 (of 49,552 total)
Luis Cazares (10/9/2014)
I wasn't expecting that someone would expose their SQL instance to the internet. :crazy:
I suspect that's the situation that the OP is 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
October 9, 2014 at 10:19 am
Luis Cazares (10/9/2014)
If you can't do it the right way, you could try an alternative.
Won't help here. Login triggers only fire if the login was successful, they're not going to...
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
October 9, 2014 at 10:06 am
Is the table in question a heap? (no clustered index)
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
October 9, 2014 at 9:58 am
Could someone who knows their way around firewalls please help this network admin out?
http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx
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
October 9, 2014 at 9:57 am
But you still lose the advantage of compressed pages in memory.
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
October 9, 2014 at 9:56 am
Yes, still only three options for what to do with the connection, but on the scope page you set what IP addresses the rule applies to.
Please, get someone who knows...
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
October 9, 2014 at 9:13 am
Custom rule -> Scope
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
October 9, 2014 at 9:05 am
They're key locks. So the two processes each have an exclusive lock on a different row of the same index. Perfectly possible.
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
October 9, 2014 at 9:04 am
ALTER INDEX or ALTER TABLE with the rebuild clause.
Dedupe on the data files? That's got to be a violation of the IO requirements SQL has (once written data is not...
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
October 9, 2014 at 9:01 am
When I said speak to the network admin, I meant the person who knows their way around networking and firewalls.
I am not a network admin, I don't know firewalls well,...
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
October 9, 2014 at 8:58 am
I guess you could check sysjobs and see when the last time the index rebuild job ran. Other than that, there's no easy way to track when an index was...
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
October 9, 2014 at 8:49 am
Speak to your network admin, denying all IPs but for a range is something all firewalls should be able to do.
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
October 9, 2014 at 8:48 am
Table definitions, index definitions and execution plan please.
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
October 9, 2014 at 8:36 am
That's something you'd configure within the firewall. Speak to your network admin or ISP's network people.
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
October 9, 2014 at 8:35 am
I prefer to put the COMMIT inside the try block, rather than outside where an IF is necessary
So....
BEGIN TRY
BEGIN TRANSACTION;
-- Generate a constraint violation...
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
October 9, 2014 at 8:01 am
Viewing 15 posts - 7,546 through 7,560 (of 49,552 total)