Forum Replies Created
Viewing 15 posts - 12,886 through 12,900 (of 19,560 total)
-
RE: Cannot execute SSIS package
MostInterestingMan (8/11/2010)
Aspg (8/11/2010)
Hi All ,I have created a SSIS package on my local machine .
Now i want to run it on server .I am using sql server authentication with user...
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?
Should I have stopped at the value below?
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: Create #Temp Table using While Loop Instead of Cursor
I would really like to see a more clear definition of the requirements. There is likely an alternative set based method to accomplish your goals.
Could you provide greater detail?
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: Failed IT Projects
If we could become emotionless then that would likely have a large impact on this 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 -
RE: How many partitions?
Thanks for the question.
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: Storing Negative Numbers
tymberwyld (8/12/2010)
Well, not entirely useless, I got a good laugh as I thought about this 'ole job. Moved on to bigger and better things...so the advice was taken 😛My...
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: My MSDB Database is over 31 GB in the development server
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: Storing Negative Numbers
Lynn Pettis (8/12/2010)
Ninja's_RGR'us (8/12/2010)
Lynn Pettis (8/12/2010)
CELKO (8/12/2010)
tymberwyld (11/10/2008)
Along with a lot of other horrible decisions, I am now not allowed to use Negative numbers in any database design. Instead,...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: My MSDB Database is over 31 GB in the development server
Congrats - good to know that it is resolved.
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: My MSDB Database is over 31 GB in the development server
Shrinkfile is similar to the shrinkdatabase that you already ran - difference is in scope - one is to shrink files and the other is for shrinking the database.
update stats...
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: My MSDB Database is over 31 GB in the development server
Try this:
sp_updatestats
;
Once that is done, do this:
dbcc shrinkfile (1,100)
;
dbcc shrinkfile (2,100)
;
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: My MSDB Database is over 31 GB in the development server
My apologies, I thought you would complete the name of that table. The table is sysxmitqueue.
Run this query and show us the full results please.
/*similar to sp_spaceused */
declare @dbsize...
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: My MSDB Database is over 31 GB in the development server
I don't see the sysxmit table listed anymore. Does that show up in your results?
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!
squib
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?
Paul White NZ (8/12/2010)
Gianluca Sartori (8/12/2010)
It could get even more confusing, if you like:/snip/
Nice, isn't it?
Very nice. Hadn't seen that one before. There's so much weirdness around temporary...
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 - 12,886 through 12,900 (of 19,560 total)