Using one sproc to go against 10 different tables means that you would need to use dynamic sql rather than staight sql. This means that the caching of the query plans would need to be recalculated each time the sp is run. That is extra overhead that will ultimately cause a performance problem. As far […]
2004-01-19
1 reads
Can anyone help me with this one. I'm trying to determine why this sql7sp4-server (winnt4sp6a) is eating op more than 900Mb VM (560MbMemusage).This gradualy grows, but I cannot determine why. There are no open transactions.(Maybe cut and paste this back in notepad) ** syscacheobjects -- prepared objects ** **-------------------------------------** bucketid cacheobjtype objtype objid dbid uid refcounts […]
2004-01-13
5 reads
That didn't work for me. I wasn't able to remove the spaces. Another option is to seperate the month, day, and year with DATEPART, and then string them all together in the report. However, I am having trouble keeping the month and day in 2 digit format for dates smaller than 9, and I need […]
2003-12-16
Another way to do this is using Indentity, not using it as a property of a column, but as function in a TSQL statement. Using your example: select Identity(int,1,1) as rank, Hiredate, LastName, Firstname into #hireDate from northwind.dbo.employees where Title = 'Sales Representative' order by HireDate Select cast(rank as char(4)) as Rank, cast(hiredate as varchar(23)) […]
2003-12-08
quote: To the best of my knowledge the answer is no. I also know of no tool to correct a broken file. Even i can open (in HEX) the backup file and verify the data is inside ??? I think is just a matter of structure of bak file. Anyway .. thanks a lot
2003-11-26
OK, never mind. Found the book online (took a lot of searching, for some reason). It's called "Dangerous Visions" (1967) and I highly recommend it for SF and/or trip (ta) fans.
2003-09-12
Thanks guys - we've just placed the order for a per-processor license which will allow us to communicate with the server across a number of domains Thanks MK
2003-07-29
2 reads
quote: I agree with what has been stated. I use testing,BOL and searching the Web to find answers depending on the question. I don't have SQL200 and since most of the questions are for SQL200 I have to search or best guess anyway but at least it will prepare me for when we do get […]
2003-07-24
My fault on the English - we haven't decided what to do just yet. Clearly if can't follow the article it's of no value, yet we don't have time to rewrite content that comes in from readers who use English as a second language. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-21
quote: Inattention using master..xp_cmdshell can seriously endanger SQL Server security This article rightfully points out that you tend to avoid xp_cmdshell for security reasons, but then goes and uses the sp_OA* procedures, which you tend to avoid for security and stability reasons. Therefore, I don't think the author can cite security as a reason for […]
2003-07-21
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