Viewing 15 posts - 44,206 through 44,220 (of 49,552 total)
If you want someone to rewrite the query, you're going to have to help them.
Please give us the table structure (as create table statements), the index definitions (all 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 25, 2008 at 10:35 am
Use Jacob's version, it's faster than the convert to varchar and back. See my blog for the details.
And please don't shout at us. (post in all caps)
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 25, 2008 at 10:23 am
There's a post on Paul Randal's blog on how to 'hack' a corrupt DB back into a server after it was detached. It's one of the more recent entries.
http://www.sqlskills.com/blogs/paul
Also note...
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 25, 2008 at 10:21 am
Only in SQL 2008, and that's just a cpu-time and memory priority. If a kill command is issued against your session, it will be terminated.
I'm curious. Why do you need...
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 25, 2008 at 10:17 am
Have a look at the page in BoL titled "DDL Event Groups for Use with Event Notifications"
There are a few events there that aren't included in DDL triggers, but it...
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 25, 2008 at 10:13 am
Robert Davis (9/24/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 25, 2008 at 10:06 am
It's not a new data type. I know it's been around since 2000, I think it's been around much longer.
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 25, 2008 at 10:03 am
What's that query supposed to do?
How many rows are in those tables?
Can you post the table and index structures and some sample data please?
Why all the count distincts? They're very...
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 25, 2008 at 10:00 am
DonKo (9/25/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 25, 2008 at 9:57 am
Molly Cary (9/24/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 25, 2008 at 9:55 am
Jeff Moden (9/24/2008)
Yeah, but what does the OP want to do with it? 🙂
<shrug> Beats me. We'll probably never know
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 25, 2008 at 9:51 am
As far as I'm aware, it can be anywhere in the same filegroup.
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 25, 2008 at 9:49 am
varchar doesn't reserve space. If a varchar(4000) column contains only 4 characters, it takes only 6 byes to store (there are two bytes overhead because it's a variable length column)....
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 25, 2008 at 9:48 am
It's definitely the backup drive that the errors are complaining about.
write failure on backup device 'F:\MSSQL\BACKUP\MEDICAL\MEDICAL_tlog_200809240630.TRN'. Operating system error 112(There is not enough space on the disk.
Can you monitor 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
September 24, 2008 at 1:42 pm
Foreign keys are not indexes. If you want an index on the column, you'll have to add one yourself.
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 24, 2008 at 1:23 pm
Viewing 15 posts - 44,206 through 44,220 (of 49,552 total)