Viewing 15 posts - 2,221 through 2,235 (of 49,552 total)
Standard Edition AG has a single DB per AG, and two servers only. (same as database mirroring was)
If you have multiple DBs that you need to make highly available, you...
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 18, 2016 at 3:48 am
SQL Guy 1 (10/17/2016)
Maybe this is the reason?
No.
When last did checkDB succeed?
Can you manually create a database snapshot on that database?
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 17, 2016 at 4:28 pm
CheckDB shouldn't need to lock the DB. It'll only try to do that if it can't create the usual database snapshot it uses.
Are there any other messages in the error...
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 17, 2016 at 3:59 pm
aaron.reese (10/17/2016)
--Data Type considerations and mapping .NET datatypes to SQL datatypes
--Indexing strategies (Don't use GUIDs as PK, make sure...
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 17, 2016 at 1:23 pm
Anyone seen the crystal ball?
http://www.sqlservercentral.com/Forums/FindPost1826636.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 17, 2016 at 11:46 am
jasona.work (10/17/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
October 17, 2016 at 11:45 am
Gut feel here, an updated resume and a script, export, recreate (and you may not get everything back)
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 17, 2016 at 12:23 am
Why do you say the log isn't being truncated? Where are you looking and what are you expecting to see that you aren't?
It sounds like you're expecting the file size...
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 15, 2016 at 11:58 am
Since SQL executes those sequentially, there's only one running at a time. If you stop the execution (SSMS stop button or app timeout) then that session stops executing, the running...
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 15, 2016 at 3:23 am
My earlier statements stand.
Investigate your queries and make sure that what you think is happening is really happening, and targeted recompile hints on the queries are far better than on...
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 14, 2016 at 2:35 pm
river1 (10/14/2016)
Every time I call this procedures I pass difterent parameters and it seems that the query plans demage performance based on this.
With recompile might fix that, 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
October 14, 2016 at 10:19 am
I'm no sure what you're asking regarding the unlimited size. A data file won't automatically grow to unlimited (and you wouldn't want it to, that's 16TB). It'll grow by its...
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 14, 2016 at 9:18 am
No, it applies only to the procedure it's on.
Why are you planning to add it? There's very few good reasons to recompile an entire procedure.
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 14, 2016 at 8:26 am
er.mayankshukla (10/14/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
October 14, 2016 at 5:26 am
That's not an error, it's a warning that nulls are being eliminated due to aggregates.
Depending on the requirements, that may be a warning you can ignore, or an indication that...
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 14, 2016 at 5:08 am
Viewing 15 posts - 2,221 through 2,235 (of 49,552 total)