meta user
network profile
| bio | website | spaghettidba.com |
|---|---|---|
| location | Italy | |
| age | 35 | |
| visits | member for | 1 year, 9 months |
| seen | May 16 at 8:55 | |
| stats | profile views | 16 |
|
May 14 |
awarded | Caucus |
|
Apr 20 |
answered | How do I specify a linked server to a remote database over tcp/ip? |
|
Apr 18 |
comment |
How to write a script to push the server time to out? Force time synchronization in your domain. |
|
Apr 18 |
revised |
Only allow one checked row in a Column in SQL Server Added another option |
|
Apr 18 |
comment |
Only allow one checked row in a Column in SQL Server @dezso In MSSQL we have Filtered Indexes. It's the same concept. |
|
Apr 18 |
answered | Only allow one checked row in a Column in SQL Server |
|
Apr 16 |
comment |
Linked server performace issue? Service Broker could be your friend if some delay is allowed. Under normal circumnstances, the delay can be very short. |
|
Apr 4 |
awarded | Critic |
|
Apr 4 |
comment |
Need help in converting this cursor to a set based operation RichardTheKiwi's answer looks good. However, I would check if populating a 8 million rows (temporary?) table from a 8 million rows (temporary?) table is really what you want to do. You probably want to process the results further and the temp table looks like a waste of resources. The same results can likely be achieved querying the original table(s) directly. |
|
Apr 3 |
comment |
Bandwidth comparison between log shipping and transactional replication The two techniques do very different things, so I'm not sure it's worth the time comparing them. |
|
Mar 20 |
answered | Merge Replication identity field issues |
|
Mar 20 |
comment |
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs @Sebastian Thanks for clarifying. Actually, I have a "vote to delete this post" link next to the edit link. Maybe it's a privilege unlocked with more rep than I have. |
|
Mar 20 |
answered | SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs |
|
Mar 20 |
comment |
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs @Sebastian you're right, I'll try to be less "tranchant" in the future. However, trying the backup/restore solution would have saved a lot of time and increased the knowledge of the OP more than any baked solution we may post. |
|
Mar 20 |
comment |
Create Temp Table From Stored Procedure Result You may need to add "SET FMTONLY OFF" before the stored procedure execution inside the OPENROWSET function. |
|
Mar 19 |
comment |
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs Why haven't you actually tried it before posting? |
|
Mar 7 |
answered | Copy Permission From Windows Based user To Local user |
|
Mar 6 |
comment |
SQL Server alter table to change TEXT to NVARCHAR(MAX) greatly increasing database size Have you tried with RoKa's suggestion? |
|
Mar 6 |
answered | SQL Server alter table to change TEXT to NVARCHAR(MAX) greatly increasing database size |
|
Mar 5 |
revised |
Are “create user” and “grant connect” functionally equivalent? typo |
