Viewing 15 posts - 5,266 through 5,280 (of 49,552 total)
Depends on how much data is in that column. It's a fully logged operation, so you need log space > size of data being affected (in this case the varchar(8000)'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
July 17, 2015 at 1:58 pm
jotate (7/17/2015)
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
July 17, 2015 at 1:48 pm
You don't have enough space in the log for the ALTER. It's a single transaction, so recovery model doesn't apply (and please make sure you fix the broken log chain...
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
July 17, 2015 at 7:59 am
First question. Why are you implementing mirroring on SQL 2014 when it's been deprecated for two versions and will probably be removed soon?
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
July 17, 2015 at 6:18 am
Depends. Have the tables changed (data wise) in the last year?
Do you have scheduled index and statistics maintenance? Do you have auto_update_statistics turned on?
It might be stats, but it might...
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
July 17, 2015 at 4:03 am
And that's about all the patience I have this week for 'tell me how to do my job' type posts. At least today's going to be a short work day.
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
July 17, 2015 at 3:21 am
In one phrase: Network latency. What's the latency from the east cost users to the west coast server? That latency will be added twice to every request they make (added...
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
July 17, 2015 at 3:20 am
Weird. I had problems initially enabling query store, but once enabled it worked fine.
Can you post a screenshot of Object Explorer expanded out?
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
July 17, 2015 at 3:17 am
In future please post in the correct forum section. Posting a 2008 question in the 2014 forum means you'll get answers relevant for SQL 2014
The very first hit from google...
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
July 17, 2015 at 3:09 am
Just make sure you change them back immediately after the insert, or you may have some nasty blocking problems.
As for service pack, that server really needs to be upgraded. 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
July 17, 2015 at 2:57 am
Bharatvip (7/16/2015)
During the test things start slowing down and that is what is causing concerns.
Then you need to identify why things are slowing down. What are the bottlenecks? What 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 recoverability
July 17, 2015 at 2:55 am
You can, and there are plenty of tutorials and how-to articles online. Google should turn up piles.
That said, should you be doing that? Do you understand what that will mean...
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
July 17, 2015 at 2:49 am
Probably bad plan, parameter sniffing or similar, maybe due to stale stats. Can you post the actual execution plan (not the estimated, the estimated is going to be useless 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
July 17, 2015 at 2:47 am
dba-wannabe (7/16/2015)
Where DecryptByKey(p.SSN) = @Input_SSN_ParamWon't every SSN in the table be decrypted? Seems like a bad idea, performance-wise.
Yes and yes.
Should I/we add a column to hold a hash of...
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
July 16, 2015 at 11:49 am
Bharatvip (7/16/2015)
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
July 16, 2015 at 10:59 am
Viewing 15 posts - 5,266 through 5,280 (of 49,552 total)