Forum Replies Created
Viewing 15 posts - 7,051 through 7,065 (of 19,560 total)
-
RE: String or binary data would be truncated -- Mysterious
It looks like the view is not schema bound and the underlying table was probably updated after the view was created. When doing that, the view needs refreshed.
Run either...
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 -
RE: Performance Issue In DB
My 2 cents.
Be very cautious when running profiler on a production server because of the performance impact it can/will have.
The recommended better approach is to run a server side trace.
Like...
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 -
RE: Are the posted questions getting worse?
SQL Kiwi (1/19/2012)
GSquared (1/19/2012)
"fowl swoop"That one might be closer to fowl fell.
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 -
RE: The new Analytic functions in SQL Server 2012
Good Stuff Wayne
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 -
RE: Source or Version Control?
Cool. It should work well for you.
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 -
RE: Today's Random Word!
SQL Kiwi (1/19/2012)
Brandie Tarvin (1/19/2012)
SQLRNNR (1/19/2012)
GunganMesa don't think so. No, mesa don't.
Mensa don't think, Mensa knows.
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 -
RE: Today's Random Word!
Gungan
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 -
RE: SSIS OLEDB Destination Options
cengland0 (1/19/2012)
Evil Kraig F (1/19/2012)
Now do a datapump in SSIS 2k5 from source to target and then recheck the DataLog table. The logging will not have fired.But it will...
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 -
RE: String or binary data would be truncated -- Mysterious
You're welcome
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 -
RE: String or binary data would be truncated -- Mysterious
You're welcome.
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 -
RE: String or binary data would be truncated -- Mysterious
nawaz1774 (1/19/2012)
Oh I am sorry. I just wanted to get view from two differnt experts. I am new to the Forum Culture. Thats the reason I doono That I should...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 -
RE: keywords in sql server
No.
But in SQL Server 2008 there is the intellisense option that will produce a list of the keywords as you type.
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 -
RE: String or binary data would be truncated -- Mysterious
If the size needs to be Varchar(100) then change them to varchar(100). This depends on the max data size between the different sources as well as the business requirements.
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 -
RE: String or binary data would be truncated -- Mysterious
This is a cross-post. Same thread, two forums.
Here is the other one.
http://www.sqlservercentral.com/Forums/Topic1238442-8-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 -
RE: String or binary data would be truncated -- Mysterious
No diff on SQL version.
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
Viewing 15 posts - 7,051 through 7,065 (of 19,560 total)