Viewing 15 posts - 6,721 through 6,735 (of 11,678 total)
It certainly looks that way:
"Login timeout expired".
"A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance...
July 10, 2012 at 12:11 am
Where did you get the idea that a subquery is faster than a join?
A correlated subquery certainly isn't. If you query is slow, it's probably because you don't have the...
July 10, 2012 at 12:08 am
How to: Run a Package Using a SQL Server Agent Job
At the end of the page in the yellow box is an example.
July 10, 2012 at 12:00 am
Any reason why you want to eliminate joins?
A subquery won't perform faster.
If I were you, I would rather get rid of the subquery that's already in the query and join...
July 9, 2012 at 11:57 pm
Jeff Moden (7/9/2012)
Koen Verbeeck (7/9/2012)
Jeff Moden (7/7/2012)
Phil Parkin (7/7/2012)
SQLRNNR (7/7/2012)
I would use two file system tasks or perform the move via a script component.
I think you might mean a script...
July 9, 2012 at 4:31 pm
It sure is a good start for the workweek, fixing that impossible bug 🙂
July 9, 2012 at 5:39 am
These are the types of bugs that can drive you really mad 🙂
July 9, 2012 at 5:24 am
In TSQL it's fairly easy:
WITH CTE_Tally AS
(
SELECT TOP 100 number FROM MASTER.dbo.spt_values
WHEREtype= 'P'
AND number> 0
)
SELECT
number
,week_day = CASE WHEN (number % 7) = 0
THEN 7
ELSE (number % 7)
...
July 9, 2012 at 3:43 am
You can use the FLOOR function to get rid of the decimals.
July 9, 2012 at 3:33 am
hamsa_apj (7/6/2012)
July 9, 2012 at 3:28 am
Jeff Moden (7/7/2012)
Phil Parkin (7/7/2012)
SQLRNNR (7/7/2012)
I would use two file system tasks or perform the move via a script component.
I think you might mean a script task, and I agree.
The...
July 9, 2012 at 3:26 am
I don't know a thing about IBM MQ, but a quick Google search resulted in this:
http://stackoverflow.com/questions/2501743/ssis-and-ibm-mq-series-integration
July 9, 2012 at 3:24 am
Normally the adminstrators of the server itself (adminstrators part of the BUILTIN\Administrators group) have admin privileges in SSRS.
July 9, 2012 at 3:19 am
July 9, 2012 at 3:17 am
Viewing 15 posts - 6,721 through 6,735 (of 11,678 total)