May 3, 2012 · The number one drawback of transactional replication is its native inability to replicate batch commands quickly and consequently no predictable latency. There are ways of …

Nov 30, 2011 · I found that you can use Taks, Generate Scripts wizard from SQL Server 2008 to SQL Server 2005. It has option to script data, although we don't want to use this option on big …

Sep 10, 2008 · You can also save the Profiler data to a SQL Server table (on the File menu, point to Save As and then click Table) and run SQL queries against it. Be careful that you perform …

Aug 25, 2013 · When a database is opened for the first time on a newer version of SQL Server, the database is automatically upgraded by the database engine. ( Your scenario is making a …

Feb 23, 2015 · Looking for advise if one can use operation system commands using TSQL without enabling xp_cmdshell. actually using xp_cmdshell requires sysadmin privs which I am …

Apr 15, 2015 · I am trying to open a SQL file I generated via SQL Server 2008. The size of the file generated by SQL is 1.65 Gb.

Nov 10, 2017 · Apparently the delete 50% leaves the table in "confusing state" for the database engine optimizer. This is not supposed to happen after REBUILD-ing indexes and updating …

Jul 31, 2015 · SQL Server 2008 and SQL Server 2008 R2 are not supported on Windows 10. SQL Server 2012 requires SP2 to be compatible with Windows 10, while SQL Server 2014 requires …

Mar 14, 2008 · I am a novice to the Visual Web Developer 2008 program. I was running through the guided tour and had to skip the first step about setting up a database for the following …

Nov 10, 2008 · Date parameters are treated the same way as any other sproc parameter. I'm assuming that you mean datetime (SQL 2005), but it would be the same for Date (SQL 2008): …