Viewing 15 posts - 2,191 through 2,205 (of 49,552 total)
Go to 2016.
The testing you will need to do (and yes, you do *need* to test) will be the same for 14 or 16. As for licenses, at this point...
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 26, 2016 at 2:40 pm
If you're planning to use Availability Groups, then you don't need a shared drive. Shared drives are needed for Always On Failover Cluster, not Availability Groups. Each node 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
October 26, 2016 at 12:08 pm
flaskvacuum (10/26/2016)
This error started off since last 14th Oct till now. Guess the subsequent backup from 14th Oct onwards cannot be use for the restoration ?
Correct, they'll all have...
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 26, 2016 at 12:00 pm
124420294 (10/26/2016)
I have a issue of applying sql transaction log to database. For example,
a) create a database "testdb"
...
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 26, 2016 at 11:58 am
rodjkidd (10/22/2016)
Now the most important leg - getting it to Gail! 🙂
The rate I'm going, that might be the hard part...
Flight was originally scheduled to depart at 19h20 Saturday. It'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
October 22, 2016 at 5:22 pm
Eirikur Eiriksson (10/22/2016)
GilaMonster (10/22/2016)
Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.
This approach could...
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 22, 2016 at 4:19 pm
GilaMonster (10/21/2016)
I haven't even started packing yet and I already have flight delays. 🙁
And further flight delays, and delays upon the delays.
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 22, 2016 at 4:17 pm
Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.
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 22, 2016 at 5:12 am
rodjkidd (10/22/2016)
GilaMonster (10/21/2016)
I haven't even started packing yet and I already have flight delays. 🙁Rodney, please remember the SQLBits cup you got for me.
Bit late to remind me now :O
???...
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 22, 2016 at 4:16 am
Steve Jones - SSC Editor (10/21/2016)
robert.sterbal 56890 (10/21/2016)
I've been trying out headsets and speakers this year. I've probably spent 100-200 dollars on all the different devices I've tried.
Ahh, forgot headphones....
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 22, 2016 at 2:32 am
Phil Parkin (10/21/2016)
Is anyone experiencing the effects of this?http://gizmodo.com/this-is-probably-why-half-the-internet-shut-down-today-1788062835
Yes, with the secondary effect that the Seacom cable has a fault and so half the country's internet traffic is being rerouted...
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 21, 2016 at 2:16 pm
I haven't even started packing yet and I already have flight delays. 🙁
Rodney, please remember the SQLBits cup you got for me.
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 21, 2016 at 1:11 pm
sqlfriends (10/21/2016)
I just thought each time there is an update, it will run the update statement.
Yes, that's what will happen. Doesn't necessarily mean it's a problem worth spending...
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 21, 2016 at 11:21 am
Suggestion 3: Test and determine whether the trigger is really a problem before spending time on it.
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 21, 2016 at 10:56 am
I've spent a fair bit this year.
GT670 graphics card to replace the old, noisy one
New laptop
SSD for new laptop
New phone (the old one had a crushing encounter with the kitchen...
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 21, 2016 at 4:41 am
Viewing 15 posts - 2,191 through 2,205 (of 49,552 total)