Viewing 15 posts - 8,806 through 8,820 (of 19,560 total)
David Burrows (9/7/2011)
piet.kouwer (9/6/2011)
How can I solve this problem ?There are several ways of achieving this but we need more information
DDL to create tables
Sample data (INSERT statements)
Expected results
Agreed. With...
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
September 7, 2011 at 8:29 am
Nice question and good information for data professionals to understand.
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
September 6, 2011 at 10:02 pm
Nate Heard (9/6/2011)
Problem solved! Case of the wizard doing to much work. Thanks all.
Presuming the issue was that there was a grouping issue in the report. Is...
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
September 6, 2011 at 5:15 pm
Greg J (9/6/2011)
I've got a dedicated machine with SQL 2005 on it. I love 2008R2 and want to move to it.
1) What *media* do I need to...
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
September 6, 2011 at 5:14 pm
Jinu43 (9/6/2011)
I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.
Nope - see note from Michael.
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
September 6, 2011 at 5:07 pm
Since you don't have them already - start with this article. It will help you retrieve all of the reports quickly.
http://jasonbrimhall.info/2011/08/08/ssrs-export-en-masse/
Next, once you have the reports downloaded, you need...
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
September 6, 2011 at 4:54 pm
mister.magoo (9/6/2011)
Welsh Corgi (9/6/2011)
I would not just let anyone add values to the table. THis need to be well thought out or you will have issues.
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
September 6, 2011 at 4:41 pm
Without source control, it would be best to have those projects centrally available. Make sure you back them up frequently. I would also implement a folder system with...
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
September 6, 2011 at 4:40 pm
Welsh Corgi (9/6/2011)
I would not just let anyone add values to the table. THis need to be well thought out or you will have issues.
I add...
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
September 6, 2011 at 4:32 pm
antony-688446 (9/6/2011)
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
September 6, 2011 at 4:31 pm
cengland0 (9/6/2011)
antony-688446 (9/6/2011)
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
September 6, 2011 at 4:05 pm
Do you mean to backup the database to multiple files?
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
September 6, 2011 at 4:01 pm
I prefer to have those items pulled from a lookup table in the database.
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
September 6, 2011 at 4:00 pm
I agree on the shared datasets.
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
September 6, 2011 at 3:57 pm
Nice first list of improvements.
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
September 6, 2011 at 3:55 pm
Viewing 15 posts - 8,806 through 8,820 (of 19,560 total)