Viewing 15 posts - 46,891 through 46,905 (of 49,552 total)
I'm assuming you downloaded SQL Express. Profiler's not included in that, it's only in the non-free editions.
If you want to learn and play, download the evaluation version of SQL. 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
April 15, 2008 at 2:10 pm
Grant Fritchey (4/15/2008)
... and look at your execution plan (I'm getting sick of typing that. Anyone have a macro?)
Ctrl-C, Ctrl-V. I'm starting to keep a text file of common...
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
April 15, 2008 at 1:56 pm
.sqldb is not the extension of a SQL server database or script. SQLite is not in any way related to SQL Server
Perhaps the SQLDB viewer on this page will help...
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
April 15, 2008 at 1:49 pm
There are utilities available to decrypt stored procs. You should be able to find one with google easily.
Other option, run profiler and trace the sp_statement starting event. Then run...
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
April 15, 2008 at 1:35 pm
The error message means exactly what it says. BACKUP LOG WITH TRUNCATE_ONLY is deprecated and will not work in a future version of SQL Server (in SQL 2008 specifically). 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
April 15, 2008 at 1:33 pm
Take the tuning adviser's advice with a large pinch of salt. It was a tendency to massively over-recommend.
What I would suggest is that you try the indexes that it's suggested...
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
April 15, 2008 at 1:26 pm
Well, yes. All that's currently doing, is looping over the records. You'll need to add in logic to do whatever inside the while loop.
while (@@fetch_status = 0)
Begin
...
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
April 15, 2008 at 6:40 am
Jeff Moden (4/15/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
April 15, 2008 at 6:36 am
Dunno. Post the code please?
Make sure you've changed both of the Fetch Next ... to use the variables, otherwie you will only get the first row, 4 times.
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
April 15, 2008 at 6:24 am
Maybe. It depends on the queries run, the data distribution, the indexes you have. It's not a question that can be answered in general.
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
April 15, 2008 at 6:00 am
Pretty close. You'll need to fetch the email into a variable (ie FETCH NEXT ... INTO @SomeVariable), then the sending logic goes inside the while loop just before the FETCH.
Just...
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
April 15, 2008 at 5:44 am
Pleasure.
Just declare your variable as nvarchar(max), otherwise you risk truncation.
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
April 15, 2008 at 5:32 am
There's no way to disable an index in SQL 2000. You'll have to drop 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
April 15, 2008 at 1:51 am
If there is a non-zero wait time in the wait_time column and there is a non-null wait type in the wait type column, then this column gives details on exactly...
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
April 15, 2008 at 12:56 am
Jeff Moden (4/14/2008)
Steve, do you have a URL handy to sign up?
https://www.sqlpass.org/Summit2008/Pages/default.aspx
Are you planning on going this year?
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
April 15, 2008 at 12:24 am
Viewing 15 posts - 46,891 through 46,905 (of 49,552 total)