Forum Replies Created
Viewing 15 posts - 4,801 through 4,815 (of 49,552 total)
-
RE: Server level trigger to log activity and rollback after logging information
Eirikur Eiriksson (9/9/2015)
That implies that he can connect by other means (not mentioned in the OP).Such as the application which the user uses to do their job.
Since the request...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: TRUNCATED Column value at MS SQL 2008
Probably because of your Management Studio settings.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Server level trigger to log activity and rollback after logging information
Few comments on the trigger first.
The execute as. Typically you'd have something like 'execute as sa', to ensure that the login trigger has enough permissions to write logging info away,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Server level trigger to log activity and rollback after logging information
Eirikur Eiriksson (9/8/2015)
Why not disable or drop the login and just log failed attempts?😎
Because doing so would prevent him from logging in entirely, whereas the trigger prevents him from connecting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Multiple SQL instance memory issue
How are you determining there's 200GB free? If you're looking at Task Manager, it'll be giving you incorrect data because you're using locked pages for the SQL instances.
Try using the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: tempdb configuration for 24 logical cores
https://technet.microsoft.com/en-us/library/ms191433%28v=sql.105%29.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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Left Join with 2 references
Really not much more advice I can offer without having some data to work with.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Recompiling
That entire page is misleading. Not so much wrong, as inadequate and hence misleading.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Left Join with 2 references
Try
left join table2 b on a. prod_code = b.prod_code or a. prod_type = b. prod_type
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: The Scientific Method
Ok, now how do you tell that the boundaries are 'properly filled'?
The developer says so?
The items are checked off on a list?
No bugs have been found?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Remove String from column Post Code Field
Is it always a single word, followed by a space, followed by the correct data?
Or, is it always two 3-character strings with a space at the end with the illegal...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: The Scientific Method
That's a very simplistic view.
If the developer says the software is working 100%, and to his knowledge it is working 100%, does that mean that it works and there are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: TSQL Short-circuit
David Moutray (9/7/2015)
Just for the record, I believe a good solution has the following characteristics:1. It gets the job done
2. It performs well and it scales well for a wide...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Sql Server Agent Service
You mean Availability Groups with synchronous replicas?
SQLAgent should be running. Jobs should have logic to check whether they're running on the primary replica or not, and if not to 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Recompiling
So write up a test and prove that BoL is wrong. Not hard thing to test.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 4,801 through 4,815 (of 49,552 total)