Viewing 15 posts - 43,966 through 43,980 (of 49,552 total)
Sanaullah (10/7/2008)
AS the values are changing every second the in procedure we should use
WITH RECOMPILE, So wheen ever it is called it recompiles the query and get the last 50...
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
October 7, 2008 at 7:02 am
Jeff Moden (10/7/2008)
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
October 7, 2008 at 6:59 am
Quit the 8-5 job and started consulting.
I have hectic days where I work to midnight and I have mostly free days. It's awesome.
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
October 7, 2008 at 5:32 am
Good point. You may need the serialisable then. Leave the xlock. It saves SQL having to convert an updlock into an xlock for the insert.
As for the isolated, in terns...
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
October 7, 2008 at 5:31 am
Backup.. with no log shouldn't be run at all.
You're discarding log entries and breaking the recovery chain. Practically what it means is that if the latest full backup fails...
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
October 7, 2008 at 5:24 am
Is it possible that something could be using the backup file? An anti-virus, a copy?
Why are you doing a backup log with no log before the full backup? How often...
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
October 7, 2008 at 4:26 am
This is interesting.
I ran a very simple workload in 2008's DTA against the AdventureWorks database. When I ran it to my 2008 server, I got no results. When I ran...
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
October 7, 2008 at 4:19 am
Ahmad Osama (10/7/2008)
1) Is it possible to have a NULL value in a foreign key field?
Sure, providing the column is declared nullable.
does Foreign key allows a column to be nullable.
Yes,...
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
October 7, 2008 at 4:06 am
Swirl80 (10/7/2008)
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
October 7, 2008 at 4:00 am
Ahmad Osama (10/7/2008)
Hi All,Here are few interview questions..
1) Is it possible to have a NULL value in a foreign key field?
Sure, providing the column is declared nullable.
2) If I have...
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
October 7, 2008 at 3:36 am
That's the process ID (pid) of the SQL server executable. You'll find it in Task Manager.
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
October 7, 2008 at 3:32 am
Well, someone had to do it. The usergroup's been dead for over a year. Now I actually have some time to do stuff like this.
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
October 7, 2008 at 3:31 am
As an example:
select c.AccountNumber, soh.OrderDate, soh.SalesOrderNumber from Sales.Customer c
inner join Sales.SalesOrderHeader soh on c.CustomerID = soh.CustomerID
where SalesPersonID = 282 and c.TerritoryID = 6
select c.AccountNumber, soh.OrderDate, soh.SalesOrderNumber from Sales.Customer c...
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
October 7, 2008 at 2:42 am
jacob sebastian (10/7/2008)
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
October 7, 2008 at 2:34 am
A restore creates the database exactly as it was at the time of backup, tables, indexes, etc. There's no rebuild necessary at all.
What you do need to do after upgrading...
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
October 7, 2008 at 1:38 am
Viewing 15 posts - 43,966 through 43,980 (of 49,552 total)