Viewing 15 posts - 10,351 through 10,365 (of 49,552 total)
Maybe, maybe not. There's a hell of a lot of factors involved.
Again, why is it a concern? It's not as if you can replace an insert with an update just...
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 19, 2014 at 10:23 am
Nick Doyle (1/17/2014)
1. Should I really be concerned with the extent scan on indexes? It doesn't appear Microsoft felt it important enough to include in the DMV.
It's kinda there....
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 19, 2014 at 4:55 am
The most common reason for a DB to restore and remain in the restoring state is the person running the restore ran RESTORE DATABASE ... FROM DISK ... WITH NORECOVERY,...
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 19, 2014 at 2:46 am
I would ask why it matters. If you need to change a value in a row, you need to update. If you need to put a new row in 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 19, 2014 at 2:24 am
It also takes effect immediately, no restart necessary.
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 17, 2014 at 2:27 pm
Without seeing the query, no.
Could be parameter sniffing, could be lack of parameter sniffing, could be better row estimates on table variables, could be related to catch-all queries, could 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
January 17, 2014 at 2:16 pm
The 'ad hoc distributed queries' option has nothing to do with the plan cache. Setting it on enables the OPENROWSET and OPENDATASOURCE commands
Were you thinking of 'optimise for ad-hoc queries'...
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 17, 2014 at 2:14 pm
MysteryJimbo (1/17/2014)
This can be done online in most cases with a short lived schema modification lock.
If the split involves moving rows from one partition to another, it's not going...
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 17, 2014 at 9:07 am
kbhanu15 (1/17/2014)
HI All,Can any one help me how to create COMPUTED columns on DATEADD(yy, -1, GETDATE()) ?
What have you tried so far?
1. Instead of this DATEADD(yy,...
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 17, 2014 at 1:50 am
TheSQLGuru (1/16/2014)
GilaMonster (1/16/2014)
TheSQLGuru (1/16/2014)
IIRC explicit drops aren't even honored any longer...
They are, they always have been. Drop a temp table and you can't access it any longer. Essential when testing...
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 16, 2014 at 10:23 pm
New Born DBA (1/16/2014)
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 16, 2014 at 10:22 pm
TheSQLGuru (1/16/2014)
Not enough time to check, but does tempdb.sys.tables show temp objects that aren't yours?
Yes
Also, does it provide a name that is "droppable"?
No, though you could probably write...
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 16, 2014 at 10:21 pm
New Born DBA (1/16/2014)
Why its not a good practice to implement TDE?
No one said it's not a good practice. What we said is it is not going to meet your...
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 16, 2014 at 2:51 pm
New Born DBA (1/16/2014)
What else can be done besides implementing tde?
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 16, 2014 at 2:47 pm
SQL_Surfer (1/16/2014)
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 16, 2014 at 2:45 pm
Viewing 15 posts - 10,351 through 10,365 (of 49,552 total)