Extending Tempdb Log
Feb 14, 2001I seem to have a problem extending the log portion of tempdb onto a log device used by another user defined database. Is this a known problem?
Thanks
ADVERTISEMENT
Extending Functions In SQL 7.0?
Jun 18, 1999Is there a way to add functions to SQL (other than stored proceedures) to emulate functions in other systems?
I would like to create a FOXPRO type OCCURS function:
Select * FROM Table1 WHERE OCCURS('Y', FLAGS) > 3
If FLAGS is a VARCHAR(7) and equals "YYYYNNN" then OCCURS would return 4 and the row would return. The database that I am
accessing has >165,000,000 rows and >500 columns per row so you see that I need all the speed I can get!
'
' This is a VB function which works.
' Can this be compiled into a DLL and
' somehow made available to SQL?
'
Public Function OCCURS(expr1 As String, expr2 As String) As Integer
Dim i As Integer
Dim count As Integer
For i = 1 To Len(expr2)
count = count + Abs((Mid(expr2, i, 1) = expr1))
Next
OCCURS = count
End Function
Need Help Extending A Query
Sep 21, 2005I need some help forming a query
I have 3 Tables...
Table1: Users
Fields: UserID Int
Username Varchar(50)
Table2: User_Categories
Fields: User_CatID Int
User_ID Int
Table3: Categories
Fields: CatID Int
Catname Varchar(100)
Now consider Table 3 has the following values
CatID | Catname
1 | cat1
2 | cat2
3 | cat3
4 | cat4
5 | cat5
6 | cat6
7 | cat7
8 | cat8
9 | cat9
Now I need to select users who fall into the categories with CatID 5, 1, 3. Also users can fall into more than one category.
The users should be sorted by the 1st the users who fall under 5, then users who fall under 1 and then the users who fall under 3 and then finally by the userID in the descending order.
SELECT userid, username
FROM Users, User_Categories
WHERE userid=user_catid AND user_catID IN (5, 1, 3)
ORDER BY userid DESC;
How do I extend this to get the above needed result? Any help will be highly appreciated.
Help Extending Query
Jun 16, 2008Hi,
If anyone can help me extending the following query I'd be really grateful! :)
I have 4 tables, Product, RawProduct, RawProductPriceHistory and RawProductPromotionalHistory. The relationship is a Product can have multiple RawProducts (one for every retailer the product is stocked in), and the PriceHistory and PromotionalHistory tables keep track of when the RawProduct's price changes, and when it comes on or off of promotion.
I have the following SP to return prices for the given Product for the given Date.
I need to extend the SP so that it also returns details from the RawProductPromotionalHistory table if a PromotionalHistory entry occurs for the passed date (@Date). We determine whether a PromotionalHistory exists by whether the passed @Date >= RawProductPromotionalHistory.StartDateTime and @Date <= RawProductPromotionalHistory.EndDateTime. The EndDateTime can also be NULL - indicating an ongoing promotion.
Here is the schema of the RawProductPromotionalHistory table:
http://www.boltfile.com/directdownload/rawproductpromotionalhistory.jpg
And here is the current SP:
ALTER PROCEDURE [dbo].[GetProductPricesForDate]
-- Add the parameters for the stored procedure here
@Date datetime,
@ProductId uniqueidentifier
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT
ph.[DateTime], p.Name AS 'ProductName', ph.UnitPrice, rp.RawProductId, r.LogoFileName AS 'ShopLogoFileName', r.ShopId, r.Name as 'ShopName'
FROM
Shops r
INNER JOIN
RawProducts rp
ON
rp.[ShopId]=r.ShopId
INNER JOIN
Products p
ON
p.[ProductId] = rp.ProductId
INNER JOIN
RawProductPriceHistory ph
ON
ph.[RawProductId] = rp.RawProductId
INNER JOIN
(SELECT RawProductId,MAX([DateTime]) as maxdate
FROM
RawProductPriceHistory
WHERE
[DateTime]<=@Date
GROUP BY
RawProductId
)temp
ON
ph.RawProductId=temp.RawProductId
AND
ph.[DateTime]=temp.maxdate
WHERE
p.ProductId = @ProductId
GROUP BY
ph.[DateTime], p.Name, r.Name, ph.UnitPrice, r.ShopId, rp.RawProductId, r.LogoFileName
ORDER BY
ph.UnitPrice DESC
END
If anyone can help me extend the query I'd be really grateful!
thanks in advance,
dan
Please Help Regarding Extending Ssis
Dec 8, 2006
I am confused with this topic extentded ssis.What i am diong here is creating a pipeline component and i am trying to use this component and transfer data.
What is happening here is that i create it but i dont find it when i try to include this(component) in the toolbox ->Choose items.I find my project with in tools->Attach process.
Is this a problem with anyone too....
please help.
Extending BI Studio
Nov 3, 2005Hi,
View 5 Replies View RelatedExtending Word Proximity
Jun 9, 2008Hi, I am trying to write a stored proc that would allow word proximity. I would like to define the proximity of the word so that I could ask for a word1 within 10 of word2.
I am wondering if I could get some suggestions on how to go about writing this? Should I put this in a stored proc? Should I just cursor through each row and then cursor through each word after word1?
I hope that this is clear... Thanks in advance.
Extending SSIS Container?
Jul 24, 2006
Has anyone investigated extending any of the SSIS Container classes?
I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute.
I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them.
We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself.
Any insight appreciated.
Extending Source Components?
Apr 29, 2008
How can I create a source extension that reads a text file and returns a XML file? I would like to have an xml File as output, because the information is already normalized.
If I extend the class €śPipelineComponent€? I can just define IDTSExternalMetadataColumn90 as output. And I do not want to have columns. I would like to return a xml file
Is it possible to achieve this?
Extending Native Components
Jul 18, 2006Can anyone provide any direction in extending existing SSIS components with a custom component, if it's possible at all. In some cases there are just slight bits of functionality missing that I think I could add in myself. But, I'm not much of a programmer and need a bit of help in the declaration of the component in my own custom component.
Thanks.
Programmatically Extending The Project Tree
Apr 18, 2006
Hi,
I need to write an add-in, that when installed it will add a virtual folder to the project tree (in which I can later add other stuff).
The problem is even more complicated since the project I want to extend is an SSIS project (SQL Server Integration Services), and it doesn't let you customize the project structure even from the project explorer itself (can't add folders).
I appreciate any help on this.
Thanks.
Extending Delievery Extensions In SQL Reporting Services
Jul 8, 2004Hi All
We have requirement in Reports. When ever report is sent to file share using Reporting Services File Share extension than details of that file should be saved in database.
How can we achieve this functionality? What is the best possible way of achieving this?
Please let me know the solution.
Thanks in advance
Rehan Mustafa Khan
HCL Technologies
Noida,India
Extending SQL Server 2005 Mgmt Studio?
Apr 17, 2006Hi,
I've had requests for a version of my product ViEmu, a VS.NET 2003-VS2005 add-in, which will work within SQL Server 2005 Management Studio. I had a look at the Mgmt Studio, and it seems to be a version of the VS2005 environment customized for the product. There is a registry hive along the line of the one in Visual Studio, but located in HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell.
I looked for any hint online, but it seems largely undocumented.
I tried plugging my software by writing the right 'Packages' and 'AutoloadPackages' keys, and running "SqlWb /setup", which seems to do something. Nothing happened afterwards, anyway, the DLL doesn't seem to be loaded into the process. I tried using the '/log' option, but an error message comes up (which doesn't describe the /setup option either).
Is there a way to load a VS package into SQL Server 2005 Mgmt Studio? Is this a problem with the PLK? Is it unsupported? Has anybody been successful in such a feat? Would it be ok if I hack some way, no matter how obscure? Is this deliberately turned off, as in the Express editions?
Best regards and thanks in advance,
- J
----------------------------------------------------
ViEmu - vi/vim emulation for Visual Studio
Extending The Number Of Rows Returned Per Page In RS
Jun 7, 2007Is there a way to extend the number of rows that will be returned so that Reporting services doesn't display such a large number of pages for the users to page through? It would be easier for them to "wheel mouse" through a long page on the screen.
Anyone out there have any thoughts on how this might be accomplished?
Thanks!
Travis
Extending CDOSYS Mail To Include Query Attachments??
May 18, 2004Hi,
I was wondering if anyone has extended the standard CDOSYS Mail Stored Procedure (SP) to allow it to send the results of a query as an attachment?
I have set up a SP for CDOSYS Mail as outlined in the following link:
http://support.microsoft.com/default.aspx?id=kb;de;312839&sd=tech
Currently I am using the old SQL Mail (xp_SendMail). But due to the problems with losing the MAPI connection and other limitations, I have been forced to find another solution. Using SQL Mail, I was able to add a query parameter and attach the results of the query to the email. I need to have the same functionality in CDOSYS Mail
Thanks,
Kim
Extending Derived Column Transform With Custom Function Library
Feb 16, 2007When data is imported from our legacy system, the same functions need to be applied to several columns on different tables. I want to build a kind of "Function Library", so that the functions I define can be re-used for columns in several packages.
The "Derived Column" transform seems ideal, if only I could add my list of user-defined functions to it. Basically I want to inherit from it, and add my own list of functions for the users to select.
Is this possible ?
What other approaches could I take to building about 30 re-usable functions?
Tempdb Is Skipped. You Cannot Run A Query That Requires Tempdb
Jul 14, 2004Has anyone seen the SQL Server error:
"tempdb is skipped. You cannot run a query that requires tempdb"?
We're running a .Net web application with a SQL Server 2000 backend, and we get the error intermittently. Restarting the SQL Server service seems to fix it, as it causes tempdb to be rebuilt, but this isn't a long term solution. Any direction or hints would be greatly appreciated. Thanks!
- Mike
Developing Custom Components By Extending The SSIS Stock Data Flow Components
Sep 7, 2006Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.
But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.
About TempDB
Jun 1, 2005TempDB is one of the databases equipped with MSSQL Server by default.What is the purpose of it?Why do we use this temp database?
View 4 Replies View RelatedTempdb Help
Apr 9, 2002Hi,
THis is sql server 6.5 question.
I have tempdb data device size default 2 MB, which has completely filled up. I am trying to expand data device to it.
I created new device tempdb_data_ext (250 MB) and tried to expand tempdb data device. But everytime I do it, it ends up adding space to tempdb log device. How can I expand tempdb data device?
It's extremely urgent.
Thanks
TempDB
Apr 16, 2001Hi,
How can I control the growth of tempdb in SQl server.It's growing like anything.
CAn I create some alerts or jobs and what those alerts/job are supposed to do?
All help appreciated.
Jai
Tempdb
Jun 27, 2001Hello!
This is error message I discovered in NT even viewer:
c:MSSQL7DATATEMPDB.MDF: Operating system error 112(There is not enough space on the disk.) encountered.
In SQL Server error log the errors are:
Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth..
Currently tempdb rezides on C drive and it's almost out of space.
What should I do?
Detach tempdb and then move to different drive?
What's the procedure?
Thanks
Lena
TEMPDB
May 10, 2000TEMPDB in one of our production servers does not clear up so every three to four weeks I have to restart NT. Nothing like this happens on any of the other three servers. Does anybody know where I should look at to correct the problem. I sure would appreciate it.
Thanks
Shashu
Tempdb
Feb 2, 2001I have never done this before and thought I would ask. Is it possible to detach the tempdb database, move it to another drive or partition, and then re-attach it? What would be the downside or side-affects to doing such a thing?
Thanks. JT
SQL 7.0 TEMPDB
Jan 17, 2001We want to shrink the size of our TEMPDB , Does anyone know how to without blowing it away and re creating it.
Also, our tempdb expands to occupy all available space on the server, the space is not released until the server is restarted.
Any ideas would be appreciated.
Tempdb
Oct 18, 2000Hi why I cannot backup the tempdb. Is this a normal or there is something that I am doing wrong.
Ali
Need Help Tempdb
Apr 6, 2000Hi
I get a message:
Error : 933, Severity: 22, State: 1
Logical page 258 of the log encountered while retrieving highest timestamp in database 'tempdb' is not the last page of the log and we are not currently recovering that database.
I use sqlserver -T4022 to start my SQL Server since it will not start with out it. When I start sqlserver without the option, it tells me that
Error : 615, Severity: 21, State: 1
Unable to find database table id = 2, name = 'tempdb'.
I just want my SQL Server back. Please help!
Thanks
Betty Lee
Tempdb!!
Apr 20, 2000I need to move tempdb to another drive,also increase the size.Largest database is 15GB.Can anyone suggest the size and also the exact commands to move.Do I need to backup the databases before I do this task?If SP1 is not installed,will it be o.k for me for this tempdb problem.If we have a larger tempdb like 4GB,will it effect anything?...Urgent!!
View 2 Replies View RelatedTempdb
Aug 29, 2000The tempdb has grown to over 2 GB on our DB. There are no user tables or SP in it. Is there a way to clean up and are there any consequences to this?
View 4 Replies View RelatedTempDB
Jan 13, 2000I read an article on this site by Michael Hotek re "Basic SQL Server 6.5 Configuration Options". In the paragraph about TempDB he says that you should always avoid using Temp tables in stored procs. I use this feature a lot when trying to do "not in" type queries (I filter out a portion of a larger table and then use the "not in" on the temp table rather than the entire table.)
Is there a better way to run a Not in query. I have the table well indexed (i think) but it seems to do a full table scan if I use the entire table.
Any ideas???
Tempdb Way To Big
Jan 22, 2003Our Tempdb.mdf file is 11 gigs. I have tried several things to shrink this but with no luck. Does anybody have a suggestion on how I can free up that space. I have tried to re-start Sql but that didn't do anything. I thought that there was a bug, if the files got above 4 gig that sql wouldn't clear them, but I could be wrong
I thought I could detach it, and attach a new file, but makes me nervous without knowing if that’s correct.
Thanks for the help
TempDB In RAM
Nov 3, 1999Hi,
I moved my tempdb (2MB) to RAM and restarted the server. It did restart but when I tried to connect thru ISQL, it gave me an ERROR -
A connection could not be established to <server-name> - DB-Library. Unable to Connect.
What could be the possible reason.
To move tempdb to RAM, do i just have to change the values of the MEMORY and TEMPDB IN RAM parms and restart or do I have to do anything else.
Please help.
Thanks
Nishant
TempDb In RAM
Mar 18, 1999Hi
When should I put tempdb in RAM and when should I not ?
Thanks in advance
Vijay