Forum Replies Created
Viewing 15 posts - 5,386 through 5,400 (of 5,685 total)
-
RE: Are the posted questions getting worse?
Alvin Ramard (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
Perhaps Gail could practice some archery in view of the office. Maybe aim for low down on the torso 😛Waving a shiny piece...
-
RE: No, I do not provide childcare at my technology events...
Lance Roberts (10/5/2010)
I don't need to see that kind of obscene language in emails. I've unsubscribed.?? :unsure:
-
RE: Unusual Performance Issue with odd Profiler Results
Sounds like unexpected outside pressure. I assume your drives are on a SAN. Get your network administrators to double check if your LUNs were recently shared with another...
-
RE: Are the posted questions getting worse?
GilaMonster (10/5/2010)
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.The PM's boss fully supports him. I'm an external consultant (ie slave),...
-
RE: lock on select
gheinze (10/5/2010)
Thanks to all. You were helpfull to me to understand a lot of things about locks.Now I will test on my production system and check how it behaves.
Yikes! ...
-
RE: Are the posted questions getting worse?
WayneS (10/4/2010)
Chad Crawford (10/4/2010)
GilaMonster (10/4/2010)
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just... -
RE: Parameter in select statement
Change this:
SELECT @strQuery= 'SELECT VendorId From Vendors
WHERE CountryId = '+@CountryId+' '+@CityId+'
ORDERBY CreatedDate'
To this:
SELECT @strQuery= 'SELECT VendorId From Vendors WHERE CountryId = '+CAST( @CountryId AS VARCHAR(100) )
+' '
+@CityId
+'ORDERBY CreatedDate'
I think,...
-
RE: Are the posted questions getting worse?
GilaMonster (10/4/2010)
Craig Farrell (10/4/2010)
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?... -
RE: Are the posted questions getting worse?
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?The order is...
-
RE: Disk Defrag
Jon.Morisi (10/4/2010)
Hi,I've been operating with the preference to take SQL server offline when defragmenting the disks in which SQL Server datafiles or logfiles reside on in order to avoid possible...
-
RE: Are the posted questions getting worse?
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspxThere are days I just don't want to know...
I'm apparently rather grumpy today. I had started writing a parody of how to hack...
-
RE: Audit database usage
Dant...
Dynamic SQL isn't just what's pumped in from a website. It's what's typed into SSMS, ran from a job and not proc called, etc. EXEC sp_yay @blah is...
-
RE: Converting Daily OHLCV data into weekly and monthly OHLCV
Digs (10/4/2010)
Jeff I get an Error when I run your codeFROM dbo.Tally t
INVALID OBJECT !
Assuming Jeff is busy at the moment, check my signature for the dbo.Tally. You'll want...
-
RE: How would you create this stored procedure
blacklabellover2003 (10/4/2010)
Well, the consensus is that the final check isn't necessary, my remainings concern are error-handling, emailing that rowcount automatically, and possibly lifting the phone numbers using OpenRowset.But otherwise, you...
-
RE: Women and Men - Same or Different?
jay holovacs (10/4/2010)
Craig Farrell (10/4/2010)
I would counter, however, there are women who do that. At the same time, these women, by their own gender(!) are called 'butch', 'alphagirl', ......
Viewing 15 posts - 5,386 through 5,400 (of 5,685 total)