Viewing 15 posts - 10,651 through 10,665 (of 22,213 total)
If you right-click on the tables within the Object Explorer in SQL Server Management Studio, you can select an option that lets you create a script. That's what we're looking...
July 8, 2012 at 4:49 am
Profiler won't show the code from a stored proc if you're capturing execution calls. It will only show the code if you're capturing statement calls, which you don't want to...
July 8, 2012 at 4:33 am
Nesting views, calling a view from within a view, is generally a bad practice. It leads to poor performance since, in most cases, not all the columns or tables referenced...
July 8, 2012 at 4:30 am
The differential backup is only good since your last full backup. When did you last take a full backup? And yes, you can restart the server and the differential backup...
July 8, 2012 at 4:21 am
Instead of connecting using the server name, which won't be resolving on other domains, you need to use the server IP address and port. Also, you need to be sure...
July 8, 2012 at 4:16 am
There's always the T-SQL Prettifier over at Simple-Talk.
If you're willing to spend some money though, I strongly recommend Red Gate SQL Prompt[/url]. I can't live without it. It not only...
July 8, 2012 at 4:09 am
Gail is an MCM. Amazing, wonderful, and hardly surprising. Well done!
What else did I miss?
July 6, 2012 at 6:50 am
Brendan Wong (7/3/2012)
would you think it better...
July 6, 2012 at 6:35 am
I'm not sure. I'm not seeing the issue, so I don't have any advice.
The one thing I can tell you is that you have the sql handle, so you can...
July 6, 2012 at 6:32 am
Just understand that the Profiler GUI actually pulls data using a different mechanism than trace events. So, yes, pointing the Profiler GUI at your server will put additional load on...
June 27, 2012 at 11:31 am
Reddy Ksr (6/27/2012)
i think in sql server 2008 we can rollback the committed transaction.but in server 2005 we can't.
can anyone suggest me what will be reason.
Where are you getting this...
June 27, 2012 at 6:32 am
If you're in a situation where you start a backup process and during that backup process you start a transaction. Then, the backup process completes, before the transaction. The transaction...
June 27, 2012 at 4:33 am
June 27, 2012 at 4:29 am
Viewing 15 posts - 10,651 through 10,665 (of 22,213 total)