Viewing 15 posts - 151 through 165 (of 405 total)
Nice article. I had been in production DBA role for long, I understand the thrill of the chasing a performance issue and feeling exited finding the real culprit. Most often...
December 11, 2014 at 11:45 pm
You can you the old master.dbo.sysprocesses or the newer dmv
sys.dm_exec_sessions
November 23, 2014 at 10:09 pm
It is strange when its not working for one particular date alone.
The derived column expression looks fine to me.
What is your source connection and what format you are reading...
August 11, 2014 at 4:27 am
in ssis 2005 you need to use SUBSTRING(ColumnName,1,3)
August 11, 2014 at 3:21 am
That is ia funny way to create your table.
I think you need to try the unpivot function.
March 6, 2014 at 10:10 pm
If I understand your requirement correctly, you want to move files to a new drive and rename the drive itself.
Assuming the following,
You cleanly shut down all instances, move the files...
October 18, 2013 at 4:30 am
Koen is right. What you need to do is return something like all null row and
handle this in SSRS (displaying a label on condition)
October 9, 2013 at 5:20 am
As I mentioned since both databses are in same instance, the buffer pool is shared, there wont be impact in join performance.
But normally we split databases for security or functional...
October 9, 2013 at 4:27 am
Technically if it is on the same instance, it should not create a problem.
But is it only because of the size you are going for a new database? In that...
October 9, 2013 at 4:09 am
I have used the following trick in such situations
Select '['+name+'],' from syscolumns where id=object_id('tableName')
and name not in ('a','b')
You can use the result in the seleect clause
October 4, 2013 at 3:06 am
you can use fileinfo in C#
Please see the below link.
September 6, 2013 at 6:22 am
please review the acces for the account running package. I have seen these kind of issues when running through proxies
August 27, 2013 at 5:33 am
Great introduction, Eagerly waiting for the articles. Most of the issues mentioned in this article I have faced already in development. Waiting to see whether BIML can be of help....
July 17, 2013 at 2:44 am
This may be due to some patch made on one of the servers.
Can you test with openquery to see there is no permission, configuration issues
Select * from openquery(linkservername,'select top 1...
May 20, 2013 at 11:34 pm
Many scripts available already in script section
see link below for eg
May 12, 2013 at 10:58 pm
Viewing 15 posts - 151 through 165 (of 405 total)