Depends on what kind of indexes table has. If there is a cluster index for the table, dbcc dbreindex will reorganize the data according the clustered index and fill factor. If there is not cluster index, it will just rebuild the indexes themself. You may look into dbcc indexdefrag in BOL too. Edited by - […]
2003-06-26
1 reads
You can have the job result to log in to Windows Event Log, and then write a program to notify you. There are several products outside to monitor things like this. For example NetIQ, Patrol. If your company can’t afford the cost, I the best way is to Configure a SQL Mail and then Write […]
2003-06-25
The following works for me: select 'job_ID: ' + cast(job_ID as varchar(100)) from sysjobs Also the following works: declare @job_id uniqueidentifier select top 1 @job_id = job_id from sysjobs print 'job_ID: ' + cast(@job_ID as varchar(100)) Is it possible your variable @job_id is NULL? ie. you haven't fetched a value into it?
2003-06-24
2 reads
Yes I also noticed what stax68 found and the outer joins could be your problem. However if you have true duplicates in both Case30 and CASEOLDR then this should do it. SELECT c.Case30.Case_no#, c.Last_name, c.[First Name], c.Determination, c.Sender, c.[Case Type], c.Date, c.[Qwik Due], c.[Qwik sent date], c.[Final due], c.[Final sent date], c.[on hold code], f.reportid, […]
2003-06-23
Actually, I was assured by the NetAdmin that my server was being backed up (the partitions that hold my MDF's and LDF's) as part of the backup sets with the rest of the network. The lesson I learned is that I should have been managing my own backups, not relying on someone else to do […]
2003-06-22
Some additional information that might be helpful is on this web site:
2003-06-17
1 reads
quote: Ok, maybe I missed something all this time but I have never had a special character bother other than ' as long as wrapped in single quotes 'nnnnnn'. So what is everyone running into that I have yet to hit? there are some more characters to watch. Look at this one: http://www.nextgenss.com/papers/advanced_sql_injection.pdf I've just […]
2003-06-17
Does the table exist? Before you do the insert, try select * From #Test. Are you creating the table and the building up a string with the insert syntax? If so, this should not work. Cheers, Crispin
2003-06-17
I tried using this login but not able to alter it as it says permission denied. It is able to create new proc.
2003-06-10
1 reads
Hello Cheers and thanks for your attention Now If I execute by Query Analyzer the statement: SELECT * FROM [dbname].dbo.table_name_2 work, It's OK! instead SELECT * FROM [serverName].[dbname].dbo.table_name_2 not work! Bye bye Flavio
2003-06-10
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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