Viewing 15 posts - 7,381 through 7,395 (of 49,552 total)
Barcelona10 (10/28/2014)
It is NULL when Statistics never been updated
Nope, they're 'updated' at the time they are created if at the time the table has data. Bear in mind that statistics...
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 28, 2014 at 1:14 pm
Rebuilding the cluster is the least of your problems. SQL databases cannot be downgraded in any way. Any databases attached to that 2012 instance are 2012 database and they will...
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 28, 2014 at 1:10 pm
RP1966 (10/28/2014)
GilaMonster (10/28/2014)
PatrickIndex (10/28/2014)
Don't managers create the politics in the first place?No. Everyone creates politics
They do, but there's a big difference between the politics of negotiation and consensus reaching...
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 28, 2014 at 8:01 am
PatrickIndex (10/28/2014)
Don't managers create the politics in the first place?
No. Everyone creates politics
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 28, 2014 at 7:29 am
There isn't one.
Statistics 2 years old could be fine if the table is static. Statistics 2 hours old could be outdated if the table changes fast.
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 28, 2014 at 6:58 am
The ones with dates of NULL are statistics on empty tables.
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 28, 2014 at 6:42 am
Not really. It may require a reboot of the server, so don't do it when people are using the databases.
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 28, 2014 at 6:06 am
Even if you're able to do that, there are other ways they could determine the schema, harder, but not impossible. Focus on making sure your queries are injection-proof (no concatenating...
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 28, 2014 at 6:01 am
Rather focus on making your app injection-proof.
They wouldn't have used public for this, they'd have been using whatever the application's account is, since it's a query exploiting the application's willingness...
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 28, 2014 at 5:41 am
Get hold of the installation media (ISO or DVD), run setup, select installation and run through the installer selecting the option to add another instance part way through.
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 28, 2014 at 4:08 am
banglawalas (10/28/2014)
Hi,Can you provide me with link on how to do that.
Thanx
Consider finding out how as part of your studies.
Since we're recommenfing VMWare Player, the VMWare website may...
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 28, 2014 at 4:06 am
No. If you install SSAS on a separate server, you'll need to buy licenses for that second server as well. SSAS is only 'free' if it's installed on a server...
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 28, 2014 at 3:39 am
As the error says, the subquery returns more than one row, which is not permitted in that context. You'll need to change the subquery to ensure that it only ever...
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 28, 2014 at 3:38 am
What's it waiting for?
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 28, 2014 at 2:36 am
Chapters 1 and 3 should be a good starting point http://www.red-gate.com/community/books/accidental-dba
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 28, 2014 at 2:35 am
Viewing 15 posts - 7,381 through 7,395 (of 49,552 total)