RE: Memory Conservation Threshhold
You may want to read the section called "Memory Settings" from the following link. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#ETAA
2005-02-24
hardware
Setting Default Database
I am looking to set the default database locations on our sql servers to make it easier to roll out new databases through scripts.Do you need to stop and start the SQLSERVERSERVICE for this change to take effect?Thanks in advance Carl
2005-01-17
1 reads
RE: Table size limitation on SQL update task
A trigger is a stored procedure like T-SQL that executes in response to inserts, updates, or deletes. It is not related to keys or indexes. Every table should have a primary key even if you have to add an identity column. If you have a set of columns that are unique, then they are a good […]
2004-11-29
RE: Workflow question
Hi Steve,Can you looak athttp://www3.sympatico.ca/3005/support/dts1.htmlIs it what you mean? I'm a little confused about workflow part. Thanks, Robert
2004-10-13
RE: TEXT output parameter in SP
ergh! Text! That aside I noticed in your example code that your output field is not correctly defined. It should be something like:CREATE PROCEDURE [dbo].[test] @var text OUTPUT AS -- Some SQL code GO -- end sprocThen, SQL BOL leads me to believe this would be your answer: CREATE PROCEDURE [dbo].[test] @var text OUTPUT AS […]
2004-09-06
RE: Crosstab aggregate error, A Stumper!
This have to do with how CASE works. One thing is that a CASE can only return one datatype - which one if there are multiple datatypes within the same CASE expression, is determined by prescedence. (if not explicitly casted) CASE also only evaluates if the expression is true or false. Now.... the column checked […]
2004-04-30
RE: Need to create an ongoing job that deletes all recs from a table and only retain last 21 days based on a date field?
Try something like:DELETE FROM TableX xWHERE x.DateFields < GetDate() - 21You may have to do some formatting of your date field if it contains time.Select GetDate() - 21 yields 2004-03-24 15:38:02.337 as of the time that i ran the script.Good Luck,Pete
2004-04-14
RE: what is the best way to store text data
Storing in a text column and using the Full Text Search engine does quite well. However depending on the amount of data building the Full Text index can take awhile so keep that in mind. See BOL for more info.
2004-03-26
RE: how to configure sql server 2000 and windows server 2000 in order to allow remote connection through vb
Slightly easier to bibucket49's method, but basically the same idea. On the workstation, create a new text file and name it with a .udl extension. Then double-click on the file, and you will get the same dialog to connect to database. Setup and test your connection and save it. Then open the .udl file in notepad […]
2004-02-25
RE: How do you debug a trigger?
The easiest way I have found to debug a trigger is to create a simple stored procedure that will fire the trigger. Then debug the stored procedure in Query Analyzer or Visual Studio and it will step into the trigger.
2004-02-16
1 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