Top tag
Next privilege 250 Rep.
View close votes
1 3
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
comment Cannot Delete FileStream Group from Sql Server 2008
According to the SQL Azure documentation, filegroup operations are not supported because you "cannot control the physical resources of Windows Azure SQL Database" so this may actually be intended behaviour. The DBA site might be a better place to ask, though.
awarded  Yearling
answered Can I restore an uncompressed differential backup after a compressed full backup?
comment Restore of logfiles in SQL Server
FWIW, I wouldn't do this in TSQL: it's not a good language for working with files, and using xp_cmdshell often brings up security and configuration issues. A small script in your preferred scripting language may be easier, possibly using SMO.
comment “Replicate” sql structure between testing and staging on same database instance
This seems to be a question about automating deployment of SQL Server schema and code changes. There are many different ways to achieve that: use SSDT, use a commercial product, write your own deployment tools and scripts etc. If you can make your question more precise, you may get a better response.
comment Restore SQL Server 2008 R2 Express from Description
RESTORE HEADERONLY includes the description in the result set (if that's what you meant; it isn't clear if you want to get the description from a backup file or from system tables)
comment Generic SQL Job Scheduler for multiple RDBMS's?
It isn't clear what you need to execute or how you want to execute it. Without more information, your question is asking "how can I schedule stuff on different operating systems?", which is difficult to answer. You also mention "dataflows", but controlling a workflow across multiple servers is not at all the same thing as scheduling independent tasks on multiple servers. What exactly is a "dataflow" in your case? Is it an SSIS package, a PowerShell script, a custom application or something else?
comment Backing up file groups with restore to earlier backup
This looks like a question for the DBA site, but it isn't clear what you want to do. Specifically, what does "extract into these tables" mean? Are you asking about partial backups, or file backups, or something else?
comment SQLCMD command is not able to insert accents
What is the encoding of your SQL script file?
comment Executing Child packages without using master package
The short answer is "try it and see for yourself". But it isn't clear what problem your senior is trying to solve, is your current master package solution running too slowly, or using too much CPU or RAM, or what is his concern exactly? And although it isn't really clear from your question how you would execute them, running them individually one after another could be slower than running them in parallel. But the best answer to performance questions is always "don't guess, measure it".
comment Best way to perform backups with filegroups and then restore those backups
Questions about backups usually get a better response on the DBA site, although here it looks like you're asking how to roll back individual INSERTs. If so, then using backups seems like a very awkward solution, you might consider using row versioning or timestamps instead. But your aim here isn't totally clear, so I may have misunderstood.
comment Backup sql database directly to FTP server
This is really a question for the DBA site, but the short answer is "no". As the documentation says, you can only back up to disk or tape and the only supported network location is a network share. You could look for third-party tools that map an FTP site to a share, or back up databases directly to FTP, or perhaps do something at the storage system level.
awarded  Commentator
comment Modeling staff dimension in data warehouse
I still don't understand what your fact is, or what data you're trying to analyze. The best suggestion I can make is that you read Kimball's data warehousing book; chapter 8 is actually about modelling employee data.
comment Modeling staff dimension in data warehouse
If staff are the dimension, what is the fact? Are you interested in analyzing data about the staff themselves, or about other facts (projects, records of working hours) where the staff really are a filter condition?
comment How to make a copy from a Emergency Database?
SET IDENTITY ON applies to a table, not a database
comment SQL Data Collector - SSIS required on source server?
This is probably a question for the DBA site (I've voted to move it). I have no personal experience of this feature but the documentation implies that SSIS is only required on the collector, which would fit with the general SSIS model: you only need to install SSIS on the server where you actually execute the package. Have you just tried it?
comment What does it mean if the spt_monitor - table in SQL Server is empty?
It's an undocumented system table so there's no information about whether it should or should not have a row in it. But sp_monitor is the documented way to get information from that table; what results does it return? And what version of SQL Server do you have?
comment Create a linked server with SQL Server 2012 x64
It would help if you printed the exact error message, but as a complete guess either a) the DSN exists on your workstation where VS runs but not the server where SQL Server runs, or b) the DSN is a user DSN and therefore not visible to the SQL Server service account. If it's a), create the DSN on the server; if it's b) make it a system DSN. If neither, post the precise error.
comment SQL Server 2008 R2: Restore latest backup to new database from script
The literal answer to your question is "yes". It would help if you can explain what you've already tried, what problems you have, what language you plan to script in etc. But the best thing you can do is just start trying to implement your scripts, and come back here if you have a specific problem that can be clearly defined.