Forum Replies Created
Viewing 15 posts - 13,666 through 13,680 (of 19,560 total)
-
RE: What does this error mean, and why is it being generated?
SumOfDavid (6/9/2010)
I have a procedure which loads data into a table. It first drops the indexes, then loads the data, then recreates the indexes.It generates this message (not all...
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: Alter command
Here is a quick and dirty that you could run to create all of your statements.
With MassAlter as (
Select Table_Schema,Table_Name,Column_Name,Case
When IsNull(Character_Maximum_length,0) = 0
Then Data_Type
Else Convert(Varchar(40),Data_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: Alter command
Do you know which columns need to be altered? Or are you changing every single column to Not NULL?
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!
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!
The Dixie Flatline (6/9/2010)
VUVUZELAThat's just Terrble
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: can't add ADD CONSTRAINT
Krasavita (6/9/2010)
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Base_CatalogHP". The conflict occurred in database "database1", table "dbo.Base_table1", column 'id'.".I get this error. I am trying to copy table...
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?
Stefan Krzywicki (6/9/2010)
CirquedeSQLeil (6/9/2010)
Stefan Krzywicki (6/9/2010)
Steve Jones - Editor (6/9/2010)
Whoever has Cutler can keep him.As a Packers fan, I'm fine with him right where he is.
Ship him to Green bay...
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?
Stefan Krzywicki (6/9/2010)
Steve Jones - Editor (6/9/2010)
Whoever has Cutler can keep him.As a Packers fan, I'm fine with him right where he is.
Ship him to Green bay or Minnesota -...
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: Database file placement
GilaMonster (6/9/2010)
Depends on the size and usage of the databases. SANs aren't magic solutions to storage problems, and they're not exactly cheap.Agreed and Agreed. But they should be considered....
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!
Kit G (6/9/2010)
CirquedeSQLeil (6/9/2010)
I thought a LIGER was a male Lizard and female Tiger
That would be a mighty big lizard...
yum - lizard. Blue Iguana (mexican restaurant in SLC).
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!
Kit G (6/9/2010)
Alan D. Saunders-431778 (6/9/2010)
Sorry - Wrong!Liger - offspring of a mating between Lion & Tiger.
Tigon (my contribution) ofspring between Tiger & Lion.
Not sure which way round word depends...
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?
Steve Jones - Editor (6/9/2010)
Football? I know minicamps [/url]are going on, but we're over a month away from football 😛Speaking of mini-camps, you can have Gutless err Cutler back.
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: Stored Procedure Execution
Thanks - it is a good question, good reminder, and good discussion.
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: Raw Materials - Gurgle, Incorporated
I hope it doesn't come to that. :sick:
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: Database file placement
You may want to look into getting a SAN as well. At least it should be an option.
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 - 13,666 through 13,680 (of 19,560 total)