Like most respondants we only reboot our servers when neccessary. However as an aside this means you need a scheduled job to cycle your sql logs regularly (we do once a week, but we keep more than the default 6 past logs). The first time you try and check out the log file of a […]
2003-07-09
Let me clarify the topic once again I am not doing anything with the data just inserting from one table to another Like Insert into Table1 (po_no,po_date ,…..) Select po_no ,cr_date from Table2 Both are date fields , All most other procedures and queries are running well ,one difference I noticed is startup procedure is […]
2003-07-08
Odd, when I tried it on a server with a single read-only DB I got a message database blah is read-only and it quit. Then I had to make read-write during the SP and afterwards read-only again myself. I don't have a machine to test on right off, but if I can get my hands […]
2003-06-04
If you wanted to know whether or not an index had been used within a 6 month time period, wouldn't you have to run profiler for 6 months? Maybe I'm missing something. Thanks... Kevin Lawrence
2003-06-03
2 reads
2003-06-02
Bit rought around the edges! Create Table TestII(IDi int,AID INT, [Name] Char(2)) GO Insert TestII values(1,2,'ba') Insert TestII values(2,2,'cr') Insert TestII values(3,2,'de') Insert TestII values(4,1,'ba') Insert TestII values(5,3,'ba') GO Create Function TestIII(@intAID Int) returns char(100) as Begin Declare @v Varchar(100) Set @v='' Select @v=@v+[name]+',' From TestII Where Aid=@intAid If DataLength(@v)>0 Set @v=Left(@v,DataLength(@v)-1) Return @v End […]
2003-05-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers