Problem with SQL Service Manager
heymy sql service manager automatically stops the service of sql server and then started it again, any body knows what to do, and why is that so. thanksWaqas Younis
2005-05-23
Python
RE: Excessive stored procedure [COMPILE] lock
Yes, I got a good description of the problem now. A couple of further questions: Are all of the blocked processes trying to execute the same stored procedure? Does it take a long time to compile the procedure? Have you tried using KEEPPLAN or even KEEPFIXED PLAN option hints in the procedure?
2005-05-18
2 reads
DTS Package Object Model
Does anybody know how to retrieve the list of objects to be transfered (through theAddObjectForTransfer method) within a DTSTransferObjectsTask step? The GetObjectForTransfer method requires you know the object name, owner, and type - this is the part I don't know and want to find out.Anybody?Thanks,Trevor
2005-05-17
7 reads
RE: INSERT and EXEC creating transaction
Typically all SQL operations will run in a transactional context. Look at autocommit mode in the BOL index. Check out the subtopic Autocommit Transactions. HTH,
2005-05-17
RE: Excessive stored procedure [COMPILE] lock
Chris, I am also puzzled why this is happening every 3-4 days. Base table is modified every hour. I think SQL Server is forcing recompilation of all procedures referencing base,mail, table when certain threshold of modifications reached and it beleives statistics is out of date. Would you agree? When [COMPILE] locks were generated, there […]
2005-05-17
4 reads
RE: Not returning all rows using BETWEEN operator
Its interesting. I saw this exact same question just a day or so ago. The reason is that your date column isn't a date column. Its a datetime column. '05/07/2005' equates to '05/07/2005 12:00am'. If you want to include everything from 5/7, you should add a day and use < @dteTo (if you continue to […]
2005-05-06
RE: Create an ALERT for successful Backup ???
Jeff, Hint for restore: select * from sysmessages where... There are a couple of IDs for Database and log restore: 18267, 18268 and also for file restore 18269For tracking DDL I would use Profiler Trace with T-SQL Statement Completed Event and TextData filter on a particular statement and DatabaseID for a particular database. Do not […]
2005-05-06
1 reads
Openxml()
I have an xml file like: <ROOT> <LINE> <NAME>NAME1</NAME> <VALUE>VALUE1</VALUE> <productcode>product1</productcode> </LINE> <LINE> <NAME>NAME2</NAME> <VALUE>VALUE2</VALUE> <productcode>product1</productcode> </LINE> </ROOT>and I want to load into two different tables like: table 1:id name value1 name1 value1 table 2:id name value2 name2 value2 How do I seperately load this into these two tables? Please help Kins
2005-05-06
1 reads
RE: Converting a varchar to datetime
Not to piddle, but this will perform better.update Inventory set DateColumn = convert(datetime, DateStringColumn, 101) where isdate(DateStringColumn) = 1
2005-05-06
Best way to store HTML?
I am writing a little app that will store news items, such as press releases, events, headline stories, etc. I was considering just putting each item into a nvarchar field, but that seems wrong for some reason. How would you recommend that I accomplish this?BTW, I don't expect the data to get any longer than 8000 characters.
2005-04-29
2 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers