Search results for query: *

Thanks, that's all I needed to hear. I don't really understand style sheets and how they do or don't interact with SQL SERVER. Well Done is better than well said - Ben Franklin

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...

Thanks everyone for all your input. The issue was resolved and I've started working at the first-place company (as Santa said) last week. After a few emails back and forth she finally got it and left me alone. Also for the statement about me bragging, I don't think I was. It was just me...

I think I will put what Santa say in an email format and send it to her. She emailed me again last night. So I will reply with this wonderfully thought out response. Thanks Well Done is better than well said - Ben Franklin

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...

Thanks Denny, I ran a UPDATE STATISTICS yesterday (which was the first thing I thought of) to no avail. Not until I detached with UPDATE STATISTICS did the problem go away. But who knows. Well Done is better than well said - Ben Franklin

For anyone that might be interested in the fix: After restoring a Sql Server 2005 database with a Full Text Index from one environment to another, you may find that any queries that use your FTI running very slow. To resolve this issue, detach and then re-attach your database. I also...

No SQLSister...Dev and Prod has the same, QA has more. Well Done is better than well said - Ben Franklin

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...

You can have a star from me George [thumbsup2] Well Done is better than well said - Ben Franklin

In this situation I would say be yourself. The people that are interviewing you already know your work habits and your skills level. I think if you try to put on any acts you might send the wrong signal. I've work with the gov't before and they like to promote from within. So as long as you...

My last assignment was to build a tool just for that purpose (a tool to find objects in your database(s) that's no longer used). It works on 1 DB or across multiple DB's. So if an object in DB1 is referring an object in DB1 it will flag it, also if an object in DB1 is referring an object in...

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" />...

I get it. When running the first 2 queries the value replicated is the char value of '1'. This will cause replicate to truncate at 8000 charaters (via BOL). If we were to explicitly set the value to be replicated to varchar(max) or nvarchar(max) we would see the full datalength return...

I'm dumb [sadeyes] Well Done is better than well said - Ben Franklin

I haven't worked with datalength in a while so I misunderstood the meaning. But I think I got it. If I'm correct I will say why I put the first answer of 16. Well Done is better than well said - Ben Franklin

if I look up what datalength means is that cheating [bigears] Well Done is better than well said - Ben Franklin

Well Done is better than well said - Ben Franklin

you could do something like this. -- For 2000 select Parameter_name from INFORMATION_SCHEMA.PARAMETERS where Specific_name='RR_Rescodes' and Parameter_name!='' --For 2005 select * from sys.parameters where object_id=object_id('RR_Rescodes') and name !='' Well Done is better than well said -...

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