Viewing 15 posts - 1,426 through 1,440 (of 1,518 total)
Muhammad Furqan (2/21/2008)
then why do is a CLR needed. here is the answer
i have a table like this
table=mytable
table_name column_name value
tableA col1
tableB col2
now the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 11:34 pm
Muhammad Furqan (2/21/2008)
i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" are...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 11:24 pm
In dynamic SQL you can use the QUOTENAME() function to delimit your objects with [...]:
'USE ' + QUOTENAME('master', '[');
will give you
USE [master];
Off topic, the QUOTENAME() function has an interesting application...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 12:55 pm
andym0908 (2/21/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 12:11 pm
colin Leversuch-Roberts (2/21/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 12:01 pm
Jamie Longstreet (2/19/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 9:49 am
Thanks guys, I will follow your suggestions.
Thanks for the valuable input.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 21, 2008 at 8:35 am
My question is can I have the SQL Server which hosts the datasource on Service Pack 2, while the reporting services and its databases are on SP1? I don't want...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:55 pm
Also keep in mind that AWE benefits only the data cache; other parts of memory utilization, such as procedure cache, do not benefit.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:18 pm
dbcc memory status command in that it is showing awe allocated is 0.
AWE memory is dynamically allocated according to the needs of your environment. Stress your server and you will...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:15 pm
Hi all,
What is the best way of preparing for the simulations in 70-431?
I do have the Microsoft certification book for the exam:
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft® SQL...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 9:57 am
Jeff, I'd be interested in something like this as well, I'm based in Mississauga.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 8:59 am
biju127 (2/19/2008)
As i had already mentioned there is also a another instance which is now in production.
Is the suggested method is the safer one?
If yes then what are the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:53 am
On the subject of SQL Profiler, SP:StmtCompleted should be one of the events to monitor.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:38 am
I believe it is possible to actually trace the running of the code in a similar manner to how one would do so with .NET code in Visual Studio.
However, I...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 12:37 am
Viewing 15 posts - 1,426 through 1,440 (of 1,518 total)