Viewing 15 posts - 4,936 through 4,950 (of 19,560 total)
Here's an article on how to do that
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2013 at 8:14 am
john.arnott (3/8/2013)
Revenant (3/8/2013)
SQLRNNR (3/8/2013)
opc.three (3/8/2013)
JAZZ Master (3/8/2013)
crookj (3/8/2013)
SQLRNNR (3/7/2013)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Tether
Tie
Bolo
Whip
Rawhide
Eastwood
West Side
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2013 at 8:11 am
If you feel you must move them, then script out the drop statements for the FKs, script out the table move to the new filegroup, and then script out the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 4:07 pm
Quick article on how to do this here
http://saveadba.blogspot.com/2012/02/move-clustered-index-new-filegroup.html
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 3:34 pm
You can probably get better performance by creating an index on intID and bintTimeStamp.
But you really should not do select * in these queries for better performance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 9:14 am
alan_lynch (3/8/2013)
Cannot deploy the report because...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:57 am
opc.three (3/8/2013)
JAZZ Master (3/8/2013)
crookj (3/8/2013)
SQLRNNR (3/7/2013)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Tether
Tie
Bolo
Whip
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:54 am
GilaMonster (3/8/2013)
UncleBoris (3/7/2013)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:52 am
mtassin (3/8/2013)
SQLRNNR (3/7/2013)
Looks like we may have a fun day with this question.
Well.... probably.... I got it right... I noticed the backwardsness... but the other two were obviously wrong... always...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:40 am
Christian Buettner-167247 (3/8/2013)
Upfront: The MSN article is for SQL Server 2000! Here is the link to the version for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:39 am
Which Patch level of 2012 are you running?
RC0
RTM
or SP1?
I ran into an issue like this on a Win7 box with RC0 that was excessively frustrating. In the end, I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 8:35 am
And please post index definitions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 12:14 am
The size of that database is not preventing your instance from starting. Check the logs and see if you have another error when you try to start the service...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2013 at 12:06 am
What is the error?
What is the message from the maintenance plan log?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:29 pm
Manually grow your log file (it seems your instance is started since you were able to retrieve those db settings already).
USE [master]
GO
ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'DATABASENAME_Log',...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:27 pm
Viewing 15 posts - 4,936 through 4,950 (of 19,560 total)