Viewing 15 posts - 7,381 through 7,395 (of 49,571 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...
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...
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...
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
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.
October 28, 2014 at 6:58 am
The ones with dates of NULL are statistics on empty tables.
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.
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...
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...
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.
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...
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...
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...
October 28, 2014 at 3:38 am
Chapters 1 and 3 should be a good starting point http://www.red-gate.com/community/books/accidental-dba
October 28, 2014 at 2:35 am
Viewing 15 posts - 7,381 through 7,395 (of 49,571 total)