meta user
network profile
| bio | website | about.me/DavidForck |
|---|---|---|
| location | Missouri | |
| age | 26 | |
| visits | member for | 2 years |
| seen | May 15 at 13:56 | |
| stats | profile views | 40 |
I'm a database developer for a CRO that does pharmaceutical and chemical studies. My duties include: designing and building databases, troubleshooting database performance issues, building SSRS reports, installing and configuring SQL Server (2005 and 2008), configuring SQL Server security, configuring SSRS security, and some other stuff.
I also build on-line surveys in PHP using a MSSQL Server 2005 backend for an Economic Development Consulting company.
|
Apr 3 |
comment |
How can I set the index fill factor back to server default? Also, went into designer, removed the pk, saved, then readded the pk, same thing. |
|
Apr 3 |
comment |
How can I set the index fill factor back to server default? Weird. I right-clicked - script- drop and recreated the index, removed the fillfactor line and executed, and it's now specifying 95 for the fillfactor (same as the server). |
|
Apr 3 |
asked | How can I set the index fill factor back to server default? |
|
Mar 28 |
comment |
SQL Server 2012 backward compatibility for backups with 2008 Similar question on SO: stackoverflow.com/q/1744808/95710 |
|
Mar 28 |
comment |
SQL Server 2012 backward compatibility for backups with 2008 Yup, I've had this exact same problem before. Ended up scripting out the entire database and then scripting out all of the data. Red Gate's SQL Compare and Data Compare came to the rescue that day. |
|
Mar 28 |
comment |
Does the order of columns has a significant effect on INSERT? I mainly keep it in the same order for consistency. Copy/paste FTW! |
|
Mar 27 |
answered | Recommendations on creating user-objects on system database |
|
Mar 27 |
comment |
Storing date as integer (numeric), what are the advantages I'd like to see the case where you filter a query by joining to a date table with the dates stored as numeric and filtering those numeric dates would beat using "where [date] between @startdate and @enddate" |
|
Mar 27 |
answered | Storing date as integer (numeric), what are the advantages |
|
Mar 27 |
comment |
Storing date as integer (numeric), what are the advantages If you're running SQL Server 2008 or higher, you can actually just use the data type Date. It's a bit smaller and doesn't force you to include time, but almost all of SQL's datetime functions still work for it. |
|
Mar 23 |
asked | What is the signifigance of a fillfactor of 20? |
|
Mar 23 |
comment |
Behavior of data in indexes based on fill factor OK, so I was wrong with how the behavior worked. Thank you for such a detailed answer! |
|
Mar 23 |
accepted | Behavior of data in indexes based on fill factor |
|
Mar 23 |
asked | Behavior of data in indexes based on fill factor |
|
Mar 21 |
answered | Why is this Full Outer Join not working? |
|
Mar 21 |
comment |
Restoring a database is not working Are you restoring to the same server, or a different server? If it's a different server, make sure that it's the same version. |
|
Mar 17 |
revised |
Access SQL Server from a different subnet fixed title, cleaned up languange in body |
|
Mar 16 |
comment |
Reindex Task Failing Randomly Have you looked to see if there is anything else that's running around the time the maintenance plan fails? |
|
Mar 16 |
revised |
What is the impact of large varchar data types on indexing? cleaned up title and body |
|
Mar 16 |
suggested | suggested edit on What is the impact of large varchar data types on indexing? |
