Viewing 15 posts - 3,766 through 3,780 (of 49,552 total)
It won't run, because you're referencing an alias in the WHERE clause. Aliases only get assigned at a point after the WHERE has run.
You could do
SELECT change_dtim,create_dtim,ckpt_id,Format([change_dtim]-[create_dtim],'hh:nn:ss') as tempo FROM...
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
January 23, 2016 at 4:43 am
Eric M Russell (1/22/2016)
GilaMonster (1/22/2016)
Eric M Russell (1/22/2016)
A dirty page is simply a page that been written to during an active (ie: uncommitted) transaction.
Or a committed transaction. It's a page...
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
January 23, 2016 at 12:21 am
Jeff Moden (1/22/2016)
I'm saying that it's no good for me and I won't have it in my shop.
Seconded.
I did a long project at a company that mandated usp_...
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
January 23, 2016 at 12:20 am
abdellahmoh2016 (1/22/2016)
It's because my boss suggested me simple like that
Then I would suggest that you suggest to your boss that this is a bad idea, overly complicated, makes auditing hell...
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
January 22, 2016 at 11:54 pm
Eric M Russell (1/22/2016)
A dirty page is simply a page that been written to during an active (ie: uncommitted) transaction.
Or a committed transaction. It's a page that has been modified...
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
January 22, 2016 at 2:44 pm
Oh, and if you used the Profiler GUI against the server, you could well have caused the crash. Wouldn't be the first time.
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
January 22, 2016 at 8:56 am
Look at the length of each of the character columns, and the length of each field you're inserting into. One is too short, you need to investigate and see which...
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
January 22, 2016 at 8:55 am
You have a lot of wait types there that are meaningless or expected. Look for one of Glenn Berry's wait scripts and use that.
The totals are also very hard 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
January 22, 2016 at 8:54 am
Somewhere you're trying to insert into a column that's too small.
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
January 22, 2016 at 8:41 am
SQL Guy 1 (1/22/2016)
They agreed with second option, but with condition that the "dirty" records will be marked somehow in the report. So they conditionally accept it.
Nice idea, but...
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
January 22, 2016 at 8:40 am
Is there some reason you've decided not to use read committed snapshot or snapshot isolation?
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
January 22, 2016 at 1:52 am
You can use a DDL trigger, but if they've got dbo rights or above, they can disable the trigger.
This is something that probably needs to be taken up with 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 recoverability
January 22, 2016 at 1:41 am
Because for procedures, the lookup for the plans in cache is database_id, object_id and some of the SET options.
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
January 21, 2016 at 12:47 pm
Personally I prefer making the database owner 'sa'. It can't cause an inadvertent privilege increase, since sa is sysadmin always, it can't cause problems as will happen if a domain...
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
January 21, 2016 at 10:56 am
Grant Fritchey (1/21/2016)
Hugo Kornelis (1/21/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
January 21, 2016 at 6:40 am
Viewing 15 posts - 3,766 through 3,780 (of 49,552 total)