Viewing 15 posts - 2,266 through 2,280 (of 19,560 total)
acapone (8/13/2014)
BTW, when I preview the data in the Excel Source editor the decimal numbers look like "0,33" for 0.33.
Try to replace the comma with decimals and wrap that inside...
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
August 13, 2014 at 1:06 pm
Sana4u (8/13/2014)
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
August 13, 2014 at 12:33 pm
Perry Whittle (8/13/2014)
SQLRNNR (8/13/2014)
I think you mean the OP created the user as FredBloggs.
yes, sorry my bad.
In the end it's just a database user and doesn't really matter what...
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
August 13, 2014 at 12:18 pm
nanoo nanoo
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
August 13, 2014 at 11:37 am
Perry Whittle (8/13/2014)
SQLRNNR (8/13/2014)
It sounds to me like you created database users as loginless accounts when you created the database users.
No, the vendor has simply create the database user as...
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
August 13, 2014 at 11:34 am
Lowell (8/13/2014)
the "correct" definition as Tom puts 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
August 13, 2014 at 11:17 am
TomThomson (8/13/2014)
SQLRNNR (8/13/2014)
The point on the second option is that the definition remains the same text as when the procedure was created with the improperly spelled name.
I guess the problem...
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
August 13, 2014 at 11:14 am
faisalfarouqi (8/13/2014)
GilaMonster (8/13/2014)
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
August 13, 2014 at 9:31 am
It sounds to me like you created database users as loginless accounts when you created the database users. Is that what you are trying to achieve?
Having loginless database users...
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
August 13, 2014 at 9:27 am
danchard (8/12/2014)
I am having trouble with SQL Server Agent on an instance of SQL 2008 R2. The agent appears to be running, but none of my scheduled jobs are...
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
August 13, 2014 at 9:21 am
Try this article that does pretty much what you are looking at.
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
August 13, 2014 at 9:19 am
As Mike said, when looking at shared storage and maintenance activities that could provoke a lot of IO, I try to keep the jobs at different times.
If shared storage 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
August 13, 2014 at 9:17 am
Sean Lange (8/13/2014)
whereisSQL? (8/13/2014)
batgirl (8/13/2014)
Sean Lange (8/13/2014)
VacationEnvy
Desire
Over (sadly)
neener neener
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
August 13, 2014 at 9:04 am
TomThomson (8/13/2014)
"The definition is untouched" - anything that says that is wrong, because the definition of a stored procedure includes its name, which is changed. It's in the first bit...
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
August 13, 2014 at 8:44 am
Embarcadero has a suite of tools that can do that.
http://www.embarcadero.com/downloads
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
August 12, 2014 at 4:37 pm
Viewing 15 posts - 2,266 through 2,280 (of 19,560 total)