Viewing 15 posts - 2,026 through 2,040 (of 3,221 total)
Tara-1044200
First be happy that your system is responding rapidly to the users needs, and you have the disc space available to continue what you are doing..
If response time slows, or...
March 13, 2010 at 9:22 pm
wwei
the ways I can let it sorted are: don't keep the original identity(the equip_id column on this example), or don't set primary key on the output table
Do not believe that...
March 13, 2010 at 8:41 pm
wwei
Thanks, if you have other questions - come on back.
March 13, 2010 at 6:00 pm
Here is the code that might do what you require:
--INdex Size Author: CirquedeSQLeil (Jason ) on SCC
Declare @DBName varchar(50)
Set @DBName = 'Yourdatabasename'
Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as...
March 13, 2010 at 11:44 am
This bit of code will set the time to be all zeroes.
DECLARE @midnight DATETIME
SELECT @midnight = DATEADD(dd,0,DATEDIFF(dd,0,getdate()))
SELECT @midnight
Here are some items for date/time you might want to add to your...
March 12, 2010 at 2:44 pm
What tables, if any have you designed so far?
What are the business rules for giving concessions?
How is the data to be added through a user interface, or?
Are the values of...
March 12, 2010 at 10:41 am
You might want to use this created by RBarryYoung
CREATE VIEW vwTableInfo
--Author: 16-March-2008, RBarryYoung SSC
AS
SELECT SCHEMA_NAME(tbl.schema_id) as [Schema]
, tbl.Name
, Coalesce((Select pr.name
From sys.database_principals pr
Where pr.principal_id = tbl.principal_id)
, SCHEMA_NAME(tbl.schema_id)) as...
March 12, 2010 at 9:15 am
As per Jeff change your final select statement to:
SELECT * FROM equip_output ORDER BY equipnum
--giving you this output
equip_idequipnumpaid
4 44200 ...
March 11, 2010 at 9:35 pm
Try this
SQL Server 2008 Books Online (November 2009)
http://msdn.microsoft.com/en-us/library/ms190464.aspx
Think it has all that your need.
March 10, 2010 at 9:56 am
Still, a great question. I really hope that Paul and Kimberly continue to submit questions, even if they don't have a seminar to promote.
Heck either way. I've had...
March 10, 2010 at 8:40 am
I need to also track what procedure is performing the update
Assuming (and you know what that makes of me = SELECT SUBSTRING('assuming',1,3))
The following code will return all stored procedures that...
March 9, 2010 at 3:32 pm
Vijji-429978
You will get tested assistance if you post the table definitions, some sample data and what you have attempted. Following the suggestions contained in the first link of my...
March 9, 2010 at 2:38 pm
Roy Ernest
If a SQL Saturday was arranged in our tiny island of Curacao, Would any of you ladies and Gents show up for it?
Using this site, I think by...
March 8, 2010 at 3:32 pm
Look at the dynamic managment view to see if it has what you are looking for.
sys.dm_db_index_physical_stats
March 8, 2010 at 12:20 pm
Tom.Thomson
If clear warnings were given at first offence the continued offending should make them comparatively easy to fire.
Used to work for company where the first offense was titled...
March 7, 2010 at 5:41 pm
Viewing 15 posts - 2,026 through 2,040 (of 3,221 total)