Viewing 15 posts - 18,376 through 18,390 (of 59,070 total)
Ed Wagner (2/15/2016)
Jeff Moden (2/12/2016)
Ed Wagner (2/12/2016)
Lynn Pettis (2/12/2016)
Grumpy DBA (2/12/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 8:25 pm
Orlando Colamatteo (2/15/2016)
It can skip databases: https://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/It can be very disruptive. Scary fact: Maintenance Plans used to rely on the proc, may still.
Thanks, Orlando. The good news is that...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 7:56 pm
ramana3327 (2/15/2016)
If you are not using enterprise edition, I think it would be ok with rebuild indexes weekly using maintenance plans
Maintenance plans will rebuild ALL the indexes... even the ones...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 4:49 pm
e.hoxholli (2/15/2016)
How can I create a trigger to update rating to rating+1 if audio='choose one format' ?The database model is located below .
Looking at the ERD you provided, you need...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 4:47 pm
e.hoxholli (2/15/2016)
How can I create a trigger to update rating to rating+1 if audio='choose one format' ?The database model is located below .
Have you ever created a trigger before?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 4:16 pm
Michael1 (2/15/2016)
I haven't used SQL or SQL server in three years.
I have been charged to do the migration of a 2008 SQL Server database to 2012 SQL Server.
In addition minor...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 4:10 pm
Orlando Colamatteo (2/15/2016)
Ramesh Saive (3/6/2009)
There is an undocumented system procedure that executes any T-SQL query in all databases.EXECUTE sp_MSforeachdb 'EXECUTE sp_spaceused'
Just in case anyone else happens to stumble on this...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 4:07 pm
Thanks, Ben. I appreciate the very kind feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 2:39 pm
Sean Lange (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 2:28 pm
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 2:24 pm
Sergiy (2/14/2016)
Jeff Moden (2/14/2016)
Sergiy (2/14/2016)
I wonder - how long the SELECT part of the query would take?
The DELETE part would probably take as long as not doing any deletes and...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2016 at 9:32 am
Nope. I'm not 100% sure (and I think the mechanism has changed over the years). I'd do just like you said. I'd have to rig up a...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 14, 2016 at 9:33 pm
Sergiy (2/14/2016)
I wonder - how long the SELECT part of the query would take?
The DELETE part would probably take as long as not doing any deletes and would probably delete...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 14, 2016 at 8:59 pm
AZ Pete (2/14/2016)
The table is very large - about 250GB.
AZ Pete (2/14/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 14, 2016 at 8:52 pm
Orlando Colamatteo (2/14/2016)
That could also work but will require more downtime. You are somewhat fortunate in this case that the PK is nonclustered.
Perhaps not so fortunate. If the FILL...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 14, 2016 at 8:39 pm
Viewing 15 posts - 18,376 through 18,390 (of 59,070 total)