Viewing 15 posts - 17,566 through 17,580 (of 19,560 total)
Ray K (2/4/2010)
mbricker-600840 (2/3/2010)
I work in Newark, Ohio - live in Norwich.I work in a giant basket. No... really. Google Longaberger Office and click images.
As Maxwell Smart used to say,...
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
February 4, 2010 at 7:34 pm
If you want the indexes and such to follow, you should script it out and execute that script on the destination. Another option is to use a tool Such...
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
February 4, 2010 at 7:18 pm
The Dixie Flatline (2/4/2010)
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
February 4, 2010 at 7:09 pm
And with the rollback, you must wait it out.
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
February 4, 2010 at 7:01 pm
Standard.
Unless you need additional features and functions, then I would go Enterprise. However, Enterprise edition is very expensive.
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
February 4, 2010 at 6:58 pm
carloparcon (2/4/2010)
im quite new in sql environment,
what do you mean sp_oa?clr? im sorry, could...
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
February 4, 2010 at 6:40 pm
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
February 4, 2010 at 5:31 pm
current session.
From MSDN
This setting affects the interpretation of character strings as they are converted to date values for storage in the database. It does not affect the display of date...
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
February 4, 2010 at 5:29 pm
if you set a default on the field to accept a specific format - it should convert it for you.
Are you capturing more information than that? If you know...
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
February 4, 2010 at 4:02 pm
That is a good suggestion.
My question is why create a primary key like this? Do you ever need to increment the alpha part of the PK?
Have you considered a...
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
February 4, 2010 at 3:45 pm
if you import the date into a datetime field and then use the following:
SELECT convert(varchar,convert(datetime, '2/4/2010'),103)
You should be able to accomplish what 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
February 4, 2010 at 3:35 pm
MANU-J. (2/4/2010)
Better take it in a sql table and format it there.MJ
I would go with this suggestion. Change the format from sql 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
February 4, 2010 at 2:53 pm
I think the snake's out of the bag on that one 🙂
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
February 4, 2010 at 2:51 pm
adjudicate
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
February 4, 2010 at 2:29 pm
You're welcome.
btw - my search criteria
sql 2005 system tables diagram
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
February 4, 2010 at 1:29 pm
Viewing 15 posts - 17,566 through 17,580 (of 19,560 total)