Viewing 15 posts - 6,556 through 6,570 (of 19,560 total)
The first one is how the FK is currently defined. The nocheck there tells it to not check existing data.
The second statement enables the foreign key.
Does that help?
Gail -...
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 30, 2012 at 2:44 pm
Please post all replies to the initial thread:
http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx
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 30, 2012 at 2:39 pm
When you deploy your RDL, it imports the code into the database on SQL server.
You can extract the RDL from there (see this article: http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/ )
It is easiest to see...
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 30, 2012 at 2:37 pm
Nice tool
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 30, 2012 at 2:20 pm
Rod at work (3/30/2012)
SQLRNNR (3/30/2012)
Rod at work (3/30/2012)
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 30, 2012 at 2:17 pm
Brandie Tarvin (3/30/2012)
SQLRNNR (3/30/2012)
crookj (3/30/2012)
SQLRNNR (3/30/2012)
Revenant (3/30/2012)
crookj (3/30/2012)
SQLRNNR (3/29/2012)
Revenant (3/29/2012)
SQLRNNR (3/29/2012)
L' Eomot Inversé (3/29/2012)
crookj (3/29/2012)
SQLRNNR (3/29/2012)
saltPepper
Sergeant
Strawberry
Fields
Forever
Mr Kite
Benefit
Cost
analysis
PKI
FYI
Great SNAKES!
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 30, 2012 at 2:16 pm
dipmala.shende (3/30/2012)
Hi..I got 1,6 as output..
I run this query on SQL server and got the same output.
Please let me know how we can get 2 as output.
The request was number...
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 30, 2012 at 9:58 am
crookj (3/30/2012)
SQLRNNR (3/30/2012)
Revenant (3/30/2012)
crookj (3/30/2012)
SQLRNNR (3/29/2012)
Revenant (3/29/2012)
SQLRNNR (3/29/2012)
L' Eomot Inversé (3/29/2012)
crookj (3/29/2012)
SQLRNNR (3/29/2012)
saltPepper
Sergeant
Strawberry
Fields
Forever
Mr Kite
Benefit
Cost
analysis
PKI
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 30, 2012 at 9:57 am
This is not normal.
It sounds like there may have been an IO problem during the rebuild of an index that affected it.
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 30, 2012 at 9:47 am
Can you run that proc as that user from within a query window?
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 30, 2012 at 9:37 am
Unlike Tom, I am not a Confio Evangelist.:-D
My opinion on the tool - two thumbs up.
If you have the opportunity to use - take that advantage.
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 30, 2012 at 9:36 am
That user doesn't appear to have permissions on the proc being called from the job.
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 30, 2012 at 9:34 am
Rod at work (3/30/2012)
tom.wauters (3/30/2012)
My first thoughts for your problem:
1. Make sure that the person who develops the report in SSRS 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
March 30, 2012 at 9:29 am
Rod at work (3/30/2012)
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 30, 2012 at 9:25 am
Revenant (3/30/2012)
crookj (3/30/2012)
SQLRNNR (3/29/2012)
Revenant (3/29/2012)
SQLRNNR (3/29/2012)
L' Eomot Inversé (3/29/2012)
crookj (3/29/2012)
SQLRNNR (3/29/2012)
saltPepper
Sergeant
Strawberry
Fields
Forever
Mr Kite
Benefit
Cost
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 30, 2012 at 9:22 am
Viewing 15 posts - 6,556 through 6,570 (of 19,560 total)