Reputation
4,135
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 8 29
Newest
 Excavator
Impact
~440k people reached

1d
comment How can I do a SQL Server 2000 bak?
Dear God, get yourself a real backup of the databases immediately. A million things can go wrong with the MDF file.
Apr
29
reviewed Reject Get Job id OR Job name from within executing job
Apr
29
comment Easy way to have non-tech users modify database?
so basically you want to keep everything in excel but you want to utilize SQL Server to import it, clean it, and spit it back out into Excel? Do you think a simple SSRS report that's accessible by everyone would be a useful solution to sharing excel files or no?
Apr
28
comment Powershell Invoke-Sqlcmd Implicit Transaction
Pardon for not answering your question but I have found invoke-sqlcmd to have some bugs when I was using it and found it much easier to just call osql or sqlcmd from powershell and get similar functionality. Even the MSSQL DSC code uses OSQL internally instead of invoke-sqlcmd because workflows like DSC were having incompatibility issues with invoke-sqlcmd
Apr
27
comment Suggestions for indexes or how to partition a table in SQL Server 2008R2
quick question, are these very wide rows? Why are you looking at partitioning for for a few million rows? Is it more for performance, isolation, or both? Are these 2 tables (dataset and sales), if you have a way to throw up a example schema and data it would be helpful. Esp if we see the data types.
Apr
27
reviewed Approve Import a Oracle DMP file into a Fresh install of oracle
Apr
26
comment SQL Server data file growing
Can you run a 'space used- top tables' from SSMS when it fills up, and also are you sure it's not the transaction log that's the issue? Verify your log file isn't the one that's growing as well please
Apr
26
comment Identity column jump in sql server restart
That might get him in trouble with auditors, typically it's recommended to turn that off. What has your experience been with it though?
Apr
26
revised For about ~50,000 - 100,000 records, how much RAM is required for analysing?
edited tags
Apr
26
comment For about ~50,000 - 100,000 records, how much RAM is required for analysing?
Hi. What DBMS are you using and how wide are your records? Edit the question and present the info you will need to hold and how long it should be able to expand up to and what type of data it will be.
Apr
26
reviewed Approve PL/SQL Can't grant privileges while logged as system
Apr
26
reviewed Edit Incorrect database backup file size in SQL Server 2008 R2
Apr
26
revised Incorrect database backup file size in SQL Server 2008 R2
Corrected Spelling,
Apr
25
comment Add New Cluster node
@A_A You can absolutely use a HA and DR solution using SQL FCI's (shared storage) and AGs (Non shared storage). It's just the way you're doing it is you're only adding a 3rd node to a FCI. You want to add an AG. The link I had listed in my answer under 'this guide works well' is a good one to just setup AG. It seems you already have your FCI setup. Are you able to check Failover Cluster Manager to ensure your FCI is setup the way you want? If so, then move on to the AG portion. Again though, I stress do not try this in prod without careful understanding and testing.
Apr
22
comment Clustered Index Misunderstanding
@FLICKER I would say your understanding is pretty accurate and Martin Smith's answers goes in depth. In effect it would be relatively correct to state that 'a clustered index is a table, but it's ordered based on what key you give it'. That is a fair statement to make for a first run through. It has a lot of other considerations though such as how the data get's stored (Row ID for example as we discussed and how it retrieves the data). I'd say review the link and come back with questions on that since it's in depth.
Apr
21
answered Clustered Index Misunderstanding
Apr
21
answered Add New Cluster node
Apr
21
reviewed Edit Restore Database using GUI - Wrong file to restore
Apr
21
revised Restore Database using GUI - Wrong file to restore
Fixed Grammar, Corrected Spelling
Apr
14
comment What to do when handed a server the first time?
@rk13 thanks for pointing out trace/profiler. To this day I interchange them sometimes improperly. I was pointing out some of the other issues I've seen with server traces whereas a extended event will let you log all the data on another machine completely. It might be cool to check out in this case. If you're comfortable with the trace though go for it! There's nothing wrong with a quick working solution that won't have a negative impact. I'm personally just overly cautious.