New answers tagged

3

The best match to your requirement that I can think of is the Query Designer in SSMS. You can open the designer by right-clicking any table in your database and selecting "edit top 200 rows". Then, open the SQL pane by clicking the button in the toolbar: Now you can paste your statement in the SQL pane and use the syntax checker to convert the code: ...


4

Microsoft recommends you update to both the latest SP and the latest CU which means SP3 and CU2. As a side note if you used WSUS with the right classifications ticked this is how it would be updated "automatically". I wouldn't recommend this but it does help when explaining your update policy to users. For future versions you can also check ...


2

Assuming native mode here... The main thing you are migrating when doing the upgrade to SQL Server 2014 is the reports, subscriptions, and then your data connections. I can't think of a reason why you would need to put this database in replication just for an upgrade. Also, while it probably could be done (and work) it is not a supported method of upgrade ...


0

Are you sure /data/postgres95 is empty? If there's nothing of value in there, then run PG95=/data/postgres95 sudo rm -rf $PG95 mkdir $PG95 chown postgres:postgres $PG95 su - postgres -c 'PGDATA=/data/postgres95; initdb Then run pg_upgrade again the same way but with -D /data/postgres95 instead.


1

See this example query for getting these execution plans. Now it's ordered by CPU consumption: SELECT qs.execution_count, qs.total_worker_time/1000 total_worker_time_msec, ((qs.total_worker_time/1000)/qs.execution_count) AVGtotal_worker_time_msec, qs.max_worker_time/1000 max_worker_time_msec, qs.total_elapsed_time/1000 ...


4

You would just pull the execution plans for the most relevant queries from the plan cache. I would query sys.dm_exec_query_stats, and join to sys.dm_exec_query_plan and sys.dm_exec_sql_text to get the plan and query text, respectively. Within sys.dm_exec_query_stats you can pull queries with the highest IO, CPU, execution count, etc. - whatever is most ...



Top 50 recent answers are included