Viewing 15 posts - 42,556 through 42,570 (of 49,552 total)
Call another procedure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:48 am
You'll have to generate scripts of all of the objects in the DB - tables, views, procedures, functions, users, etc. Then you'll have to export the data. bcp works, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:48 am
Database restores (including log restores)
Autoclose (a good candidate on SQL Express)
Some sp_configure alterations
DBCC FREEPROCCACHE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:32 am
Post it on Connect and see what the MS people say.
The info bar at the bottom of the screen does change colour (in SQL 2008) based on what server you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:31 am
umanpowered (11/5/2008)
the table. The 'modify_date' is still showing the previous date.
I'm using the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:26 am
You can restore the backup to 2008. Databases can always be upgraded in version, never downgraded.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:26 am
Try something like this
SELECT * , ROW_NUMBER() OVER (ORDER BY ID) % 2 AS AlternatingFlag
FROM SomeTable
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 1:19 am
madhu.arda (12/4/2008)
is that possible that the dead lock happened in different database 12 which not mentioned in the dead lock graph?
The dead lock resources were on the two tables in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 12:40 am
As I said above, you don't need an update in the trigger. The trigger is fired by an update, there's no need to repeat that update within the trigger.
You don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2008 at 12:38 am
That kind of catch-all query doesn't perform well at all. On SQL 2000 there's no way to make it perform well
Have a look at this thread - http://www.sqlservercentral.com/Forums/Topic599065-65-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:27 pm
sp_help 'tbl'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:23 pm
Use dateadd to remove 8 hours from the two datetimes. Is it because sharepoint stored times in GMT?
SELECT NVARCHAR1, NVARCHAR6, DATEADD(hh,-8,Datetime1) as StartTime, DATEADD(hh,-8,Datetime2) AS EndTime
FROM PROWSS_Content.dbo.alluserdata
WHERE DATEADD(dd, DATEDIFF(dd,0,getdate()),0) BETWEEN...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:20 pm
George Dickson (12/4/2008)
But SQL 2005 doesn't give you an option to place the SQL Server files anywere else, does it?
It does during the installation
I hope I don't have to re-install....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:11 pm
You don't need an update in the trigger. The trigger is fired by the update. If you want to check the new values, use the inserted table. deleted, in an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:10 pm
You can add a filter on the nvarchar6 for the room you want to display.
SELECT NVARCHAR1, NVARCHAR6, Datetime1, Datetime2
FROM PROWSS_Content.dbo.alluserdata
WHERE (DateTime1 >= DATEADD(dd, DATEDIFF(dd,0,getdate()),0) AND DateTime1 < DATEADD(dd, DATEDIFF(dd,0,getdate())+1,0))
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2008 at 2:06 pm
Viewing 15 posts - 42,556 through 42,570 (of 49,552 total)