Viewing 15 posts - 5,761 through 5,775 (of 8,753 total)
Quick solution, elementary case statement!
😎
Note: it took about 5 min to prepare the DDL and the consumable data, less than a minute to write the actual query!
/* In a safe...
April 6, 2015 at 3:05 am
newbieuser (4/5/2015)
Currently, we have SQL Server 2005 database linked to Oracle database (ANSI). We are planning on converting Oracle database to Unicode. Our customer has some scripts...
April 6, 2015 at 2:30 am
Quick suggestion, why not use Ola Hallengren's SQL Server Integrity Check rather than roll your own?
😎
April 6, 2015 at 2:22 am
guy3145 (4/5/2015)
thank for your answer!
does all provided data implies high I/O utilization in sql?
we encounter a lot of sql clients disconnected at some point of the day, it is all...
April 6, 2015 at 2:19 am
patricklambin (4/6/2015)
Hi SQL-DBA-01 ,it seems that KEEPPLAN is for mainly for queries using many temp tables
See :
I found only these links which could be interesting for you.
Cannot see this as...
April 6, 2015 at 2:14 am
rhythmk (4/6/2015)
I am getting strange error mentioned below while executing my package.
Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied
I am using SSIS 2012.
I have an...
April 6, 2015 at 1:18 am
vipin_jha123 (4/6/2015)
My requirement is to execute SSIS package, when a file is arrived at a D:\MSBI_and_SQL_Guide\Incomings folder,I do not want to start the package manually .
It is not sure...
April 6, 2015 at 12:56 am
.Netter (4/5/2015)
Can someone help me with this please
Quick thought, you cannot mix dynamic and static sql in this way, better do a full dynamic statement. Also you should work through...
April 6, 2015 at 12:32 am
xsevensinzx (4/5/2015)
GilaMonster (4/5/2015)
Grant Fritchey (3/31/2015)
Steve Jones - SSC Editor (3/31/2015)
Grant Fritchey (3/31/2015)
I use semicolons on terminators for all my statements. Everyone should.
You do or Prompt does it for you?
Well, Prompt...
April 5, 2015 at 11:42 pm
Jeff Moden (4/5/2015)
Eirikur Eiriksson (4/5/2015)
here is a partial testing code which strongly indicates that the original testing is somewhat flawed.
Sorry... I don't have the time to wade through a ton...
April 5, 2015 at 5:33 pm
homebrew01 (4/5/2015)
Seems that SQL should just care if @Col_Input is NULL or not. If so convert the 0 to ' 0...
April 5, 2015 at 5:21 pm
Jeff Moden (4/4/2015)
Got code and test data for that, Eirikur? And what is wrong with Wayne's test harness? Please be sure to include yours.
Thought you would be interested;-)
Still...
April 5, 2015 at 5:03 pm
pbyrum (4/2/2015)
I plan to reboot the server to free up memory. There is not enough memory to run the DBCC command.
Quick question, what are the server's specs and configs?
😎
April 4, 2015 at 3:13 pm
TomThomson (4/4/2015)
chrisn-585491 (4/1/2015)
“The select's easy, but the join is another thing...”
But I'm not here just to write books and make money. I'm here to say...
April 4, 2015 at 3:01 pm
Viewing 15 posts - 5,761 through 5,775 (of 8,753 total)