Viewing 15 posts - 44,146 through 44,160 (of 49,552 total)
Thanks. I'll pass that on.
There are 500 odd tables. None of the tables have hundreds of columns. Interesting, if the DBA added (to the query in sqlplus) the equivalent of...
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
September 29, 2008 at 2:09 pm
ananda.murugesan (9/29/2008)
hi sqldba,pls tell me, what is the different between incremental backup and differential backup in sql server 200?
SQL doesn't have an incremental backup. It has a full backup, a...
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
September 29, 2008 at 2:08 pm
No. The restore will restore the DB with the same number of files and filegroups as it had when it was backed up.
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
September 29, 2008 at 1:51 pm
The storage engine just does data retrieval. It's job it to get pages from disk into memory and, when necessary, back. The query processing engine operates only on pages 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
September 29, 2008 at 1:51 pm
timestamp, despite it's name, has nothing to do with time. It's a binary value unique within the DB that changes whenever the row is changed. It's more a row version...
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
September 29, 2008 at 1:49 pm
Allen Krehbiel (9/29/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
September 29, 2008 at 1:44 pm
Probably because the data type used for the indexId is a tinyint, hence only goes up to 255. 0 is the heap, 1 is the cluster, 255 is the blob....
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
September 29, 2008 at 1:42 pm
Sandy (9/29/2008)
if you are using the table for highly transactional then you can go for Table variable rather than Temp Table inside store procedure because it will be faster.
Why will...
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
September 29, 2008 at 1:37 pm
saby (9/28/2008)
Transaction information for database 'tbloy'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0: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
September 29, 2008 at 1:35 pm
davidsalazar01 (9/28/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
September 29, 2008 at 1:28 pm
iwantroot (9/29/2008)
GilaMonster
select top 20 *, cast(wait_time_ms as float)/waiting_tasks_count as Avg_WaitTimefrom sys.dm_os_wait_stats
where waiting_tasks_count>0 and wait_type not like 'Sleep%'
order by wait_time_ms desc
This is my output:
Was that while the server...
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
September 29, 2008 at 1:25 pm
cuteprabakar (9/29/2008)
Tags??? How to setup this most of suggest set in new table???(max 10 tags with 20 characters length, previously I used space separated string)
In a separate table.
This will be...
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
September 29, 2008 at 1:18 pm
As in the example I gave, just make @currentyear a parameter rather than a variable.
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
September 28, 2008 at 6:00 pm
sal527 (9/28/2008)
and cyear=(cyear+1))
Well, that's never going to be true. A value is never equal to itself + 1.
Considering that you're hardcoding 2008 in the other spot, shouldn't that...
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
September 28, 2008 at 4:43 pm
Could the inner joins be filtering out the rows?
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
September 28, 2008 at 4:34 pm
Viewing 15 posts - 44,146 through 44,160 (of 49,552 total)