Viewing 15 posts - 9,796 through 9,810 (of 39,803 total)
licenses are administrative. No checking here, so just install on a new machine, use the license, and decommission the old one so that you don't get caught in a...
April 29, 2015 at 9:21 am
Some of the downloads don't even let you enter a product key, but as Grant mentioned, it's for development.
Express, Standard, Enterprise for production.
April 29, 2015 at 9:17 am
I tend to agree with Gianluca. Some companies do value the certifications (or need them for Partner status), but many use them as a checkbox.
However, the effort to get certified...
April 29, 2015 at 9:16 am
Unless you have some field in a table that has a date stamp of some sort, you can't go back and look at sizes directly. If you have old backups,...
April 29, 2015 at 9:11 am
+1 to cunningham.
Also, what's a performance problem? Is it slower than it was before? By what metric? Or is it just that users are complaining?
April 29, 2015 at 9:06 am
You can run the Database Tuning Advisor, but be careful with the recommendations. Go slow and add one index at a time. This will give you some ideas of what's...
April 29, 2015 at 9:05 am
Search for dynamic PIVOT or crosstab on the site here. Jeff Moden has a good piece that might help you here.
April 28, 2015 at 3:06 pm
I suspect the installation failed. Might try repairing the install from setup.
April 28, 2015 at 2:13 pm
Koen Verbeeck (4/28/2015)
Steve Jones - SSC Editor (4/28/2015)
April 28, 2015 at 2:12 pm
Server or database level?
here are a few items:
April 28, 2015 at 2:11 pm
Had a funny one today. On the DLM webinar I did with Grant, we had a guy ask how to recover a master database and another one show an error...
April 28, 2015 at 2:05 pm
rustman (4/28/2015)
April 28, 2015 at 8:26 am
Ralph Hightower (4/28/2015)
2 – NOLOCK is required on every query. It makes things run faster.
Instead READ_UNCOMMITTED is suggested.
At one place I worked...
April 28, 2015 at 8:26 am
Gary Varga (4/28/2015)
April 28, 2015 at 8:25 am
Viewing 15 posts - 9,796 through 9,810 (of 39,803 total)