Search results for query: *

Wow...it's been a while since I posted or asked a question. I writing some html in my script which sends out an email and I wanted to use a style sheet, but for some reason it's not working. If I take the results of @MyHTML and paste it into notepad, save it as a html file and open it in a...

Hi all, About two weeks ago had two very intense technical interviews, covering everything from SQL Server version 7.0 to version 2008. After both interviews I had a very good feeling. Those good feelings were not in vain, I received offers from both jobs. After a lot of thinking and soul...

Hello everyone, This is related to SQL Server 2005 I have a problem. I have a FTI in 3 environments, Dev, QA and Prod. I have two queries that run against my index. Now for some reason in Dev and QA they run in 0 secs but in prod they take 6 mins. After looking at the execution plan an...

I'm not good with XML, so is there another way of doing this so if a new hold type is added (like Weekly) I don't have to rewrite my code. datetime smalldatetime, data1 varchar(10), amount float ) set @TotXML='<root> <BiMonthly datetime="apr 01 2007 00:00" data1="Cash" amount ="5" />...

Very strange question. If someone imports data into a table does it leave a trail of some sort which can show where the data came from? Well Done is better than well said - Ben Franklin

This innocent looking SP which I inherited from another programmer, which has long left the company, is taking 5-6 mins to execute. Can anyone suggest anything I can change to make it run faster? Sometimes you need a second set of eyes to see something you might of missed. BTW: Hold_RPT has...

Not sure if this should be placed here or in the 'General Database Discussion'. So let's start here. I've been pulled in to analyze our production database and help look for potential problems. I've been able to come up with some very interesting findings (much different from the analysis side...

Everyone, Is there a table, view, SP or anything to check the last time a db object was accessed. Something like (Table 1 was accessed by stored proc A on Nov 1st at 5:00 PM). And is there a way to check how long it took a Stored proc to execute? Thanks for any help Well Done is better than...

Would anyone know how to search only for text that is not commented out from the syscomments or information_schema.routines tables. example 1: create proc something as --test select somefield as 'anything' from test go example 2: create proc something2 as --test select somefield as...

I've been consulting for a while now. I'm a little tired of the constant job hunt every year when an assignment is completed. I was thinking of going back into the full-time work force but with a little hesitation; because I can’t remember the last place I worked where the employees were...

I've never tried this before, but I can't wait to try it with some of my larger tables. Enjoy... http://www.sqlservercentral.com/columnists/ibaig/3144.asp Well Done is better than well said - Ben Franklin

Hey guys and SQLSister :-) Does anyone knowns what kind of sort sql server performs when you do an ORDER BY. Is it a Heapsort, Mergesort, Insertion sort, etc...? Thanks for any information. Well Done is better than well said - Ben Franklin

SQL Server 2000 Q1: I have an ini file that I need to read via t-sql. the only way I was able to get it to work was to use the QGREP command with xp_cmdshell and querying the results. Works great but messy and if fat figure Freddy changes the ini file and put a space somewhere it doesn't...

Does anyone know how to change the directory using xp_cmdshell and then execute a cmd file from that directory? I tried the following: xp_cmdshell 'c:\abcdef\file.cmd' --fails --and xp_cmdshell 'cd c:\abcdef && file.cmd' --fails --and some other stuff I can't remember right now Well Done is...

Hello all, We are having a space issue at work and I am between a rock and a hard place. On our production machine the Trans logs are getting full really quickly (mainly due to poor programming). I was told that nothing is being allowed to move to production from UAT, so I need to come up...

I was going to post this in the DTS forum, but activity is kind of low over there. Is there a way to find out how much data a DTS package wrote to the trans log the last time it was ran? Thanks guys and SQLSister [thumbsup2] Well Done is better than well said - Ben Franklin

Is there a quicker way to do this? Sometimes I just can't think. IF NOT EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'TABLE_NAME' AND COLUMN_NAME = 'Field1') BEGIN...

As I read this forum everyday, something allot of people still have problems with is NULLS and how to use them. As I was scanning through my sqlservercentral subscription articles the other day I came across the following article about nulls. For everyone that already understand NULLS to the...

Everyone, How do I count the number of times a character shows up in a string after a certain point? Example: My_string ='abcdefghabcdefgabdeabcaba' I want to count the amount of times the letter 'a' shows up after the letter 'h' So the answer should be 5 Well Done is better than well said...

I recently realized that my resume is just a cut and paste from position to position. I would love to learn a new technology but really don't have the funds needed to attend training. Because I am not up-to-date in the newer technologies I feel I am being over looked for jobs even though I have...